PDA

View Full Version : Sum with multiple criteria across multiple sheets



bielerjd
01-16-2008, 12:18 PM
I am trying to sum the number of occurances throughout the monthly sheets labeled "a" through "f" depending on incident and by which team. My current array formula is not counting. I have attached the file.

Bob Phillips
01-16-2008, 12:43 PM
I would give some serious consideration to re-organising the data to make it simpler to analyse.

bielerjd
01-16-2008, 01:06 PM
Any suggestions

bielerjd
01-16-2008, 05:40 PM
Figured out how to do it!


=SUM((THREED(August07:January07!$B$7:$AF$7)=B$6)*(THREED(August07:January07 !$B$8:$AF$8)=1)) 1
1