Give this formula a try...

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

--
Rick (MVP - Excel)


"Richard Horn" wrote in message
...
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