Counting cell totals but omitting selected rows

Hi everyone

This may be an easy fix for you Excel gurus but I am fighting a losing fight!

In the attached spreadsheet example, I tally a number of cell ranges to get totals for gender, location, age range etc.

However, how can I do the same thing but ask Excel to omit counting these tallies if I have marked them as a duplicate? (Please not none of the names are dupicated in the sheet, the data is just generic to create a smaple sheet). I have marked the duplicates with 'Y' in Column M. Essentially, how can I tally all of the specifics I require (as shown in the sheet - gender, ethnicity etc.) but not count any rows that contain a 'Y' in Column M?

I hope this makes sense. If not, please ask me and I will clarify any salient points I've missed.

Thank you for your help

Hi

a COUNTIFS should do the trick

=COUNTIFS(C1:C4926,"Male",M1:M4926,"<>"&"Y")

You could list in O1:O25 Sunderlands towns in order to modify formula in E15

=SUMPRODUCT(COUNTIS(L$1:L$4926,O1:O25,M$1:M$4926,"<>"&"Y"))

Hope it helps