software

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,quot;lt;gt;Not Yet Presented quot;)
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,quot;lt;gt;Not Yet Presented quot;) 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: www.excelforum.com/member.php...oamp;userid=33225
View this thread: www.excelforum.com/showthread...hreadid=539171
Try this

=CountA(A1:A100)-COUNTIF(A1:A100,quot;Not Yet Presented quot;)--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: www.excelforum.com/member.php...oamp;userid=32763
View this thread: www.excelforum.com/showthread...hreadid=539171Hi Harsha,

This seems to work...

=SUMPRODUCT((B1lt;gt;quot;Not Yet Presentedquot;) (I1lt;gt;quot;Not Yet
Presentedquot;) (P1lt;gt;quot;Not Yet Presentedquot;) (W1lt;gt;quot;Not Yet Presentedquot;))

Ken Johnson=SUMPRODUCT(--(B2:AC2lt;gt;quot;Not Yet Presented quot;),--(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)

quot;harshaputhrayaquot;
gt; wrote in
message news:harshaputhraya.27bl9b_1146808201.594@excelfor um-nospam.com...
gt;
gt; Hi,
gt;
gt; I want to count the occurrences based on a particular value in
gt; particular cells.
gt;
gt; If I use a range of cells, say =COUNTIF(B2:AC2,quot;lt;gt;Not Yet Presented quot;)
gt; then it will return the count of all the cells where the string is not
gt; present.
gt;
gt; Instead of that I want to perform the operation on specific cells,
gt; say on B2,I2,P2 and W2.
gt;
gt; I tried it with one cell =COUNTIF(B2,quot;lt;gt;Not Yet Presented quot;) and it
gt; works, but it didn't work for more than one
gt;
gt; Is there any solution? Please let me know.
gt;
gt; Appreciate your time and help
gt;
gt; Harsha
gt;
gt;
gt; --
gt; harshaputhraya
gt; ------------------------------------------------------------------------
gt; harshaputhraya's Profile:
www.excelforum.com/member.php...oamp;userid=33225
gt; View this thread: www.excelforum.com/showthread...hreadid=539171
gt;

Thanks a lot Bob, the solution provided by you worked for me!!--
harshaputhraya
------------------------------------------------------------------------
harshaputhraya's Profile: www.excelforum.com/member.php...oamp;userid=33225
View this thread: www.excelforum.com/showthread...hreadid=539171