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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif using Arrays 2
sumif 2
subtotal with sumif nested 1
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
SUMIF on a Calculated Field 3
insert new row and copy formula 1
Specifying comparision criteria with SUMIF() 2
Choose dat range for sumif formula 1

Top