![]() |
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. |
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