Calculating text in a column

  • Thread starter Thread starter Livingwil
  • Start date Start date
L

Livingwil

Is there a way to add up specific text in a column?
For example, if the column had "New", "Open", and "Closed"...is there a way
to add up and give me a numeric total for all of the "New" in that column?
 
How about
=COUNTIF(B1:B10,"New")

This will work if the entries in that range are the word "New" only.
It would not work if the entry is "New and Improved", for instance.

Dave O
Eschew obfuscation
 
if Open, New, Closed are in column a, in cell where you want teh count, try
=countif(A:A, "new")
 
Assuming for this response that your column was E...

=COUNTIF(E:E,"New")

Rick
 
use the function:

=Countif(range, criteria)
either Hard-code it as:
=COUNTIF($A$1:$A$10,"New")
=COUNTIF($A$2:$A$10,"Closed")
=COUNTIF($A$2:$A$10,"Open")

or

=COUNTIF($A$2:$A$10,B1) where B1 = New
=COUNTIF($A$2:$A$10,B2) where B2 = Closed
=COUNTIF($A$2:$A$10,B3) where B3 = Open

Hope that helps,

Jim May
 
Wow! Thank you!
Dave, your added tip was awesome and worked for another column...I just took
out the spaces
ex:"newandimproved" and it worked like a champ!
 
Back
Top