Using COUNTIF on specific cells

Giganews Newsgroups
Subject: Using COUNTIF on specific cells
Posted by:  harshaputhraya (harshaputhraya.27bl9b_1146808201.594@excelforum-nospam.com)
Date: Fri, 5 May 2006

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?action=getinfo&userid=33225
View this thread:http://www.excelforum.com/showthread.php?threadid=539171

Replies