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.
|