Calculating text in a column

[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?

 

[Dave O]

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

 

[JR Hester]

if Open, New, Closed are in column a, in cell where you want teh count, try
=countif(A:A, "new")

 

[Rick Rothstein \(MVP - VB\)]

Assuming for this response that your column was E...

=COUNTIF(E:E,"New")

Rick

 

[Jim May]

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

 

[Livingwil]

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!