I want to Sumif some columns that aren't next to each other. Can that be done? Also, do I have to have to numbers to sum in the first column or can I put them in the second? Thanks.
Charles.
I want to Sumif some columns that aren't next to each other. Can that be done? Also, do I have to have to numbers to sum in the first column or can I put them in the second? Thanks.
Charles.
for q 1, use sumif(range, critiera, range1)+sumif(range, criteria, range2)
range and range1 and range 2 can be in any "order" on the sheet, just the same #of rows (or columns)
not a professional, just trying to assist.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks