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

Try this

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


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=539171

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"
wrote in
message news:harshaputhraya.27bl9b_1146808201.594@excelfor um-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!!


--
harshaputhraya
------------------------------------------------------------------------
harshaputhraya's Profile: http://www.excelforum.com/member.php...o&userid=33225
View this thread: http://www.excelforum.com/showthread...hreadid=539171