Re: Count logic question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In the cell directly below the last entry in row B, try this:

=COUNTIF(B1:B5, "PG")

This will return the count for all the PG's in the "B" column.

HTH,

PZan

--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23480
View this thread: http://www.excelforum.com/showthread.php?threadid=396293

.

Relevant Pages

Re: IF Statement
... HTH ... darkwood's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29948 ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions)
Re: column values to a cell with comma seperated
... HTH ... olasa's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17760 ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions)
Re: Copying Part of a row down part of a column
... HTH ... pinmaster's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6261 ... Prev by Date: ...
(microsoft.public.excel.misc)
Re: convert number to time format?
... HTH ... swatsp0p's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15101 ... Prev by Date: ...
(microsoft.public.excel.misc)
Re: Only 8 if A5=this, then B4=that. How can I put in more?
... HTH ... pinmaster's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6261 ... Prev by Date: ...
(microsoft.public.excel.misc)