Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif column d equals x and column a noblank
total of a column where the text is "X" and the name column is not blank.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif column d equals x and column a noblank
For which version of Excel?
"Willie Wilson" <Willie wrote in message ... total of a column where the text is "X" and the name column is not blank. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif column d equals x and column a noblank
Try this:
=SUMPRODUCT(--(A1:A10<""),--(D1:D10="x")) -- Biff Microsoft Excel MVP "Willie Wilson" <Willie wrote in message ... total of a column where the text is "X" and the name column is not blank. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif column d equals x and column a noblank
=SUMPRODUCT(--(LEN(TRIM(a2:a23))0),--(d2:d23="x"))
-- Don Guillett Microsoft MVP Excel SalesAid Software "Willie Wilson" <Willie wrote in message ... total of a column where the text is "X" and the name column is not blank. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif column d equals x and column a noblank
2003 excel
"Tyro" wrote: For which version of Excel? "Willie Wilson" <Willie wrote in message ... total of a column where the text is "X" and the name column is not blank. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
countif Column A and excule column B if it's cancelled | Excel Worksheet Functions | |||
How do I Excel countif column a =? and column b = null ? | Excel Worksheet Functions | |||
How to sum items from column A only if Column B row equals X | Excel Worksheet Functions | |||
Countif Text equals the same | Excel Discussion (Misc queries) |