Can someone help with a formula - I already have one which was done by someone else, I need to amend and was hoping there was a simpler way..

=SUM(IF('TEST'!$I$7:$I$10898>0,IF('TEST'!$D$7:$D$10898=$C6,1,0),0),0)

I have 80 different areas and want to be able to calculate how many people are down to attend from each area. My areas are in text format..

I also need to calculate in 3 other columns the amount of no shows for each area, I have 3 date options so its no shows for each date for each area?

Any help will be appreciated

Thanks