| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
[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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count letter"B" in one column based on unique value among duplicat | Excel Worksheet Functions | |||
| How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
| how can I count if column A="active" and column E="Job" in a list? | Excel Worksheet Functions | |||
| how can I count if column A="active" and column E="Job"? | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
![Richard Horn[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
