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.
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.
I would give some serious consideration to re-organising the data to make it simpler to analyse.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Any suggestions
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