Conditional counting

[Larry Whitman]

Hi,

I am trying to do a count function where a specific
condition is true. My example wants to count how many
cells in c10:c30 contain numbers greater than zero where
the person is a type "s" as defined in a10:a30.

Can anyone assist?

Thanks,
Larry

 

[Bob Phillips]

Hi Larry,

=SUMPRODUCT((A10:A30="s")*(C10:C30>0))