I need to insert a function that will look at "m/f" (Male / Female) column
and "p/s" (Primary / Secondary) column and return me a count for the Male -
Primary; Male - Secondary; Female - Primary; Female - Secondary.

Any advise is greatly appreciated.

Thank you!

=SUMPRODUCT(--(A2:A100)="M"),--(B2:B100="P"))

to give Male/Primary

Repeat as required to get M/S,F/P,F/S

HTH

"Traci B........" wrote:

I need to insert a function that will look at "m/f" (Male / Female) column
and "p/s" (Primary / Secondary) column and return me a count for the Male -
Primary; Male - Secondary; Female - Primary; Female - Secondary.

Any advise is greatly appreciated.

Thank you!

Hi Traci,

for the Male - Primary

=sumproduct(--(a2:a1000="Male")*(b2:b1000="Primary"))

change the text or use a cell reference to set the others

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Traci B........" escreveu:

I need to insert a function that will look at "m/f" (Male / Female) column
and "p/s" (Primary / Secondary) column and return me a count for the Male -
Primary; Male - Secondary; Female - Primary; Female - Secondary.

Any advise is greatly appreciated.

Thank you!

HTH,

It Works!!!

Thank you so very much! This new worksheet is going to help out
tremendously with monthly stats that I report! THANK YOU!!!

"Marcelo" wrote:

Hi Traci,

for the Male - Primary

=sumproduct(--(a2:a1000="Male")*(b2:b1000="Primary"))

change the text or use a cell reference to set the others

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Traci B........" escreveu:

I need to insert a function that will look at "m/f" (Male / Female) column
and "p/s" (Primary / Secondary) column and return me a count for the Male -
Primary; Male - Secondary; Female - Primary; Female - Secondary.

Any advise is greatly appreciated.

Thank you!

u r welcome

glad to help, thanks for the feedback
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Traci B........" escreveu:

HTH,

It Works!!!

Thank you so very much! This new worksheet is going to help out
tremendously with monthly stats that I report! THANK YOU!!!

"Marcelo" wrote:

Hi Traci,

for the Male - Primary

=sumproduct(--(a2:a1000="Male")*(b2:b1000="Primary"))

change the text or use a cell reference to set the others

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Traci B........" escreveu:

I need to insert a function that will look at "m/f" (Male / Female) column
and "p/s" (Primary / Secondary) column and return me a count for the Male -
Primary; Male - Secondary; Female - Primary; Female - Secondary.

Any advise is greatly appreciated.

Thank you!