CountIF with multiple conditions one of which needs an OR.

[Paul Clark]

Afternoon hopefully someone can help me with this issue i am having with a spreadsheet.

I need to write a formulae that counts entries that meet a couple of criteria one of which needs an OR.

I have searched many threads that say OR and countifs dont go and suggest using SUMPRODUCT but I cant seem to make it fit.

I need to count records that are male in the gender column and have a value of 4 or 33 in another column.

Any ideas I'm at my wits end.

Cheers

Paul

[benishiryo]

welcome to the forum, Paul something like:
Data Range

	A	B
1	male	4
2	male	33
3	female	33
4	male	10

=SUM(COUNTIFS(A:A,"male",B:B,{4,33}))

[Paul Clark]

Thank you so much for this that does EXACTLY what i needed.

Cheers

Paul