Nebuchadnezzar Posted November 12, 2004 Report Share Posted November 12, 2004 I know Excel is not part of Windows - but I could not find any other board that fits.I have visited the Microsoft Office Help site - with no info regarding exactly what I need to know.I am using the SUMIF function - I have data in 4 separate columns (2 are inventory counts & 2 are categories) this is done to keep separate tallies from 2 different workers, who are essentially doing the same thing. What I need to know is if I can set 2 values to both the range and the sum_range, so that I can create a running tally of all inventory instead of having to add the totals of both workers. Quote Link to post Share on other sites
robroy Posted November 12, 2004 Report Share Posted November 12, 2004 You posted in the right place. Its for any windows based program not just windows itselfI think You can do what you want but I'll have to go look. Haven't used excel for several monthsJD Quote Link to post Share on other sites
Nebuchadnezzar Posted November 12, 2004 Author Report Share Posted November 12, 2004 Arachnid - the second link you provided answers my question exactly - Thank you very much. Quote Link to post Share on other sites
martymas Posted November 12, 2004 Report Share Posted November 12, 2004 good one arachnid40obviously your not only here for your beauty.to be honest until i read this thread to me excell was short for execellent.my we learn lots on this board. marty Quote Link to post Share on other sites
mikex Posted November 13, 2004 Report Share Posted November 13, 2004 A very good forum for all M$ Office problems. I used the above board to learn different excel tricks and shortcuts.M Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.