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

countif Column A and excule column B if it's cancelled 4
count nonblank cells 3
Count the number of AutoFiltered records 6
Counting in multiple column 2
Using COUNTIF with criteria in an adjacent column? 5
Count nonblank cells based on another column 1
how to count#cells w/= value in other column and not count blank c 4
Countif function 2

Top