sumif

N

Neil

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

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

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
 
Top