Using COUNTIF on specific cells

Giganews Newsgroups
Subject: Using COUNTIF on specific cells
Posted by:  harshaputhraya (
Date: Fri, 5 May 2006


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

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:)


harshaputhraya's Profile:
View this thread: