Summing Across Worksheets with criteria

B

Brian

I would like to create a SUMIF expression that works across different
worksheets.

For example for one worksheet I have:

=SUM(IF(B2=AirHandlers!$A$3:$A$503,AirHandlers!$D$3:$D$503,0))

It works, but it only covers one worksheet. I have about 20 other
worksheets, and I'm sure there's a way of doing it without typing an IF
statement for each worksheet. What's that way?
 

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

summing across worksheets conditionally and being able to copy for 4
Require formula to search across multiple worksheets 2
count cells with multiple criteria and two rows 2
sum across worksheets conditionally 5
Sum across worksheets with indirect 5
Ranking across worksheets 3
Fill Data across multiple Worksheets - Formulas 1
Summing across several worksheets 5

Top