Using COUNTIF on specific cells

[harshaputhraya]

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

[CaptainQuattro]

Try this

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

[Ken Johnson]

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

[Bob Phillips]

=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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[harshaputhraya]

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