ExcelBanter - CountIf function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - CountIf function (https://www.excelbanter.com/excel-worksheet-functions/31792-countif-function.html)

Julie

CountIf function

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?

Bill Kuunders

One way............ could be
=COUNTIF(D3:D59,"0")-3

--
Greetings from New Zealand
Bill K

"Julie" wrote in message
...
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?

Bob Phillips

As an example

=COUNTIF(D3:D59,"0")-(D100)-(D170)-(D190)

--

HTH

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

"Julie" wrote in message
...
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?

All times are GMT +1. The time now is 12:39 AM.