Count everything in a Column "except"
 

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

Count everything in a Column "except"
 

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

Count everything in a Column "except"
 

Perfect! Thanks

"Rick Rothstein" wrote:

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

[quote=Rick Rothstein;866556]Give this formula a try...

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

--
Rick (MVP - Excel)

Hi Rick,

This formula worked great for me, but now I need to include additional exceptions (e.g. "Carried Up" and "Carried Down") Please help.

Sonya