View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default '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