Combining countifs

[tulipstreaky]

Hi,

Help needed please.

I need to combine two Countifs statements with an ‘or’ but don’t know how to do it. I’m not an excel expert as you’ll soon see.

I want to be able to look for B1’s and if either the value in Entry1 or Entry2 is greater than zero, count them. However, if they’re both greater than zero, I only want to count them once.

I’ve had a go as you’ll see from the image, but it’s not right.

I know there are 7 rows that have entries with values greater than 1, but the formula which I know is wrong, brings back 4.

I’ve no doubt this is something simple to answer but I’ve tried different ways and can’t do it.

Thanks in advance for the help.
Phill

 

[steve the fish]

Try a sumproduct:

=SUMPRODUCT(--(B3:B11="B1"),--(($C$3:$C$11+$D$3:$D$11)>0)