Count everything in a Column "except"

R

Richard Horn

I have a worksheet where one column is for the project status. I want to
count all projects with the exception of any project that has the status
"Carried Forward". Count all except Carried Forward, and do not count in the
cell is blank.

This is what I was trying to use, but does not seem to work.

Column E contains Project Status. There are 11 different possible status
entries.

Projects run through rows E8:E34 and there are blank cells which I do not
want counted.

=SUMPRODUCT(--(TRIM(E8:E34)<>"Carried Forward"))

In other words, count everything except a blank cell or a cell that contains
Carried Forward.

Thanks, Richard
 
R

Rick Rothstein

Give this formula a try...

=SUMPRODUCT((E8:E34<>"Carried Forward")*(E8:E34<>""))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Functions (Sumproduct and Countif) 5
Counting # of entries for each month, in a specific status 3
Complex Count Query 0
Count Blank Cells with Conditions 3
Count cell except those contain zero 4
use month in cell date to sum all relevant cells 2
Using COUNTIF with criteria in an adjacent column? 5
count nonblank cells 3

Top