How to count a number of instances

**jslag** · 02-25-2010, 08:08 PM

Please see attached.

In this spreadsheet, I want to find a formula that counts the number of instances where employee="DARSMI" and status="G".

I tried =countif(and(B11:B21,"DARSMI",A11:A21,"G")). That didn't work.

Any ideas?

Thanks!

jslag

**Palmetto** · 02-25-2010, 08:17 PM

See attached.

=SUMPRODUCT(--(A2:A31=D2),--(B2:B31=E2))

BTW: please post your question in the correct Forum. This Forum is for VBA programming. You should use the Worksheet Function or General Forum.

**jslag** · 02-25-2010, 08:29 PM

Hey thanks! That's very helpful.

I will post in the correct place next time.

**Palmetto** · 02-25-2010, 08:38 PM

Glad to be of help.
If you are satisfied with your solution please mark your thread as SOLVED by going to the top of YOUR first post, click on Thread Tools, then Go Advanced and choose the [SOLVED] prefix.

Feedback is always appreciated. See my signature for how to go about it.