Thread
:
'COUNTIF' and 'AND"
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Mike H
external usenet poster
Posts: 11,501
'COUNTIF' and 'AND"
Try:-
=SUMPRODUCT((A1:A5<"")*(B1:B5=""))
Extend A5 - B5 as required
Mike
"Jeff" wrote:
I have two columns of data
I want a total count (not sum) of the first column only if the corresponding
second column is not blank
--
Thanks
Reply With Quote
Mike H
View Public Profile
Find all posts by Mike H