if c4:c48 = barb

and

if e4:e48 = y

then count all the y's in a sepreate cell.

So I'm trying to count all they y's for a person... need help!

Assuming Excel 2007 or later, look at the COUNTIFS function...

=COUNTIFS($C$4:$C$48,"Barb",$E$4:$E$48,"Y")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

What version of Excel are you using?

If you have 2007 or later then what you need is the =COUNTIFS() function.Try this:

=COUNTIFS(C4:C48,"barb",E4:E48,"y")

MIKE

Ask Your Question

Weekly Poll