ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Summing Across Worksheets with criteria (https://www.excelbanter.com/excel-discussion-misc-queries/190651-summing-across-worksheets-criteria.html)

Brian

Summing Across Worksheets with criteria
 
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?
--
Brian

PS: I tried
=SUM(IF(B2='AirHandlers:StmTraps'!$A$3:$A$503,'Air Handlers:StmTraps'!$D$3:$D$503,0)) and it did not work.

Peo Sjoblom

Summing Across Worksheets with criteria
 
http://www.mcgimpsey.com/excel/threedsumif.html


--


Regards,


Peo Sjoblom



"Brian" wrote in message
...
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?
--
Brian

PS: I tried
=SUM(IF(B2='AirHandlers:StmTraps'!$A$3:$A$503,'Air Handlers:StmTraps'!$D$3:$D$503,0))
and it did not work.





All times are GMT +1. The time now is 04:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com