Countif for 2 columns
 

I need a function to count nonblank cells in column A if corresponding cells
in column B are not blank. Please help. I have tried
=countif(A2:A23,"*"+B2:B23,"*") but doesn't work

Countif for 2 columns
 

Try this:

=SUMPRODUCT(--(A2:A23<""),--(B2:B23<""))

<"" means: not equal to blank

--
Biff
Microsoft Excel MVP


"earlfj" wrote in message
...
I need a function to count nonblank cells in column A if corresponding
cells
in column B are not blank. Please help. I have tried
=countif(A2:A23,"*"+B2:B23,"*") but doesn't work

Countif for 2 columns
 

Thank you, Thank you. Works perfect. I have spent hours trying to figure this
out.

"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(A2:A23<""),--(B2:B23<""))

<"" means: not equal to blank

--
Biff
Microsoft Excel MVP


"earlfj" wrote in message
...
I need a function to count nonblank cells in column A if corresponding
cells
in column B are not blank. Please help. I have tried
=countif(A2:A23,"*"+B2:B23,"*") but doesn't work

Countif for 2 columns
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"earlfj" wrote in message
...
Thank you, Thank you. Works perfect. I have spent hours trying to figure
this
out.

"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(A2:A23<""),--(B2:B23<""))

<"" means: not equal to blank

--
Biff
Microsoft Excel MVP


"earlfj" wrote in message
...
I need a function to count nonblank cells in column A if corresponding
cells
in column B are not blank. Please help. I have tried
=countif(A2:A23,"*"+B2:B23,"*") but doesn't work