N Neil Jan 23, 2009 #1 can I use the sumif function if the "range" and "range to sum" are on multiple pages in the same file - Thank you
can I use the sumif function if the "range" and "range to sum" are on multiple pages in the same file - Thank you
M Mike H Jan 23, 2009 #2 Hi, Yes you can =SUMIF(A1:A21,"something",Sheet2!A1:A21) you don't even have to have the formula on the same sheet as either of the ranges =SUMIF(Sheet3!A1:A21,"something",Sheet2!A1:A21) Mike
Hi, Yes you can =SUMIF(A1:A21,"something",Sheet2!A1:A21) you don't even have to have the formula on the same sheet as either of the ranges =SUMIF(Sheet3!A1:A21,"something",Sheet2!A1:A21) Mike
N Neil Jan 23, 2009 #3 The range is on 3 different pages =SUMIF(A1:A21,"something",Sheet2!A1:A21) I.E.: Sheet2!A1:A21,Sheet3!A1:A21,Sheet4!A1:A21 how do I put that in the formula
The range is on 3 different pages =SUMIF(A1:A21,"something",Sheet2!A1:A21) I.E.: Sheet2!A1:A21,Sheet3!A1:A21,Sheet4!A1:A21 how do I put that in the formula
