I think
=SUMPRODUCT((A1:A5<"")*(B1:B5<""))
Jeff wanted second column to not be blank
"Mike H" wrote:

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