CountIf function

[Guest]

Hello

I have a countif function...

=COUNTIF(D359,">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?

 

[Bill Kuunders]

One way............ could be
=COUNTIF(D359,">0")-3

 

[Bob Phillips]

As an example

=COUNTIF(D359,">0")-(D10>0)-(D17>0)-(D19>0)

--

HTH

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