Alternative to COUNTIF ?

  • Thread starter Thread starter DaveMoore
  • Start date Start date
D

DaveMoore

I have 3 columns (fields): A:Name B:Gender C:Part/FullTime
and numerous records,
Gender = either "M" or "F", and Part/FullTime = either "P" or "F"

At the bottom of the working area I want to show:
Total Male FullTime
Total Male PartTime
Total Female FullTime
Total Female PartTime

=COUNTIF does not sem to be versatile enough.
Has anybody any suggestions?

Many thanks for any replies

Dave Moore
 
Hi

I would suggest using something like:
=SUMPRODUCT((B2:B1000="M")*(C2:C1000="F"))
=SUMPRODUCT((B2:B1000="M")*(C2:C1000="P"))
etc

A couple of warnings. SUMPRODUCT cannot use full columns as ranges (A:A) and
the ranges being addressed must be the same size
 
Back
Top