Using COUNTIF on specific cells

Hi,

I want to count the occurrences based on a particular value in particular cells.

If I use a range of cells, say =COUNTIF(B2:AC2,"<>Not Yet Presented ") then it will return the count of all the cells where the string is not present.

Instead of that I want to perform the operation on specific cells,
say on B2,I2,P2 and W2.

I tried it with one cell =COUNTIF(B2,"<>Not Yet Presented ") and it works, but it didn’t work for more than one

Is there any solution? Please let me know.

Appreciate your time and help

Harsha

Try this

=CountA(A1:A100)-COUNTIF(A1:A100,"Not Yet Presented ")

Hi Harsha,

This seems to work...

=SUMPRODUCT((B1<>"Not Yet Presented")+(I1<>"Not Yet
Presented")+(P1<>"Not Yet Presented")+(W1<>"Not Yet Presented"))

Ken Johnson

=SUMPRODUCT(--(B2:AC2<>"Not Yet Presented "),--(MOD(COLUMN(B2:AC2),7)=2))

should it really have those two spaces at the end of the text?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"harshaputhraya"
<harshaputhraya.27bl9b_1146808201.594@excelforum-nospam.com> wrote in
message news:harshaputhraya.27bl9b_1146808201.594@excelforum-nospam.com...
>
> Hi,
>
> I want to count the occurrences based on a particular value in
> particular cells.
>
> If I use a range of cells, say =COUNTIF(B2:AC2,"<>Not Yet Presented ")
> then it will return the count of all the cells where the string is not
> present.
>
> Instead of that I want to perform the operation on specific cells,
> say on B2,I2,P2 and W2.
>
> I tried it with one cell =COUNTIF(B2,"<>Not Yet Presented ") and it
> works, but it didn't work for more than one
>
> Is there any solution? Please let me know.
>
> Appreciate your time and help
>
> Harsha
>
>
> --
> harshaputhraya
> ------------------------------------------------------------------------
> harshaputhraya's Profile:
http://www.excelforum.com/member.php...o&userid=33225
> View this thread: http://www.excelforum.com/showthread...hreadid=539171
>

Thanks a lot Bob, the solution provided by you worked for me!!