ExcelBanter - sumif

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sumif (https://www.excelbanter.com/excel-worksheet-functions/217643-sumif.html)

can I use the sumif function if the "range" and "range to sum" are on
multiple pages in the same file
-
Thank you

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
"Neil" wrote:

can I use the sumif function if the "range" and "range to sum" are on
multiple pages in the same file
-
Thank you

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

--
Thank you

"Mike H" wrote:

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
"Neil" wrote:

can I use the sumif function if the "range" and "range to sum" are on
multiple pages in the same file
-
Thank you