Using COUNTIF on specific cells

  • Thread starter Thread starter harshaputhraya
  • Start date Start date
H

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
 
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"
 
Back
Top