CountIf function

J

Julie

Hello

I have a countif function...

=COUNTIF(D3:D59,">0")

However I need to also incorporate into this to flag 3 rows that I don't
want to include in this calculation but I'm not sure how to exclude them.

Does anyone have any suggestions?
 
B

Bob Phillips

As an example

=COUNTIF(D3:D59,">0")-(D10>0)-(D17>0)-(D19>0)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top