Countif for 2 columns

[earlfj]

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

 

[T. Valko]

Try this:

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

<>"" means: not equal to blank

 

[earlfj]

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

 

[T. Valko]

You're welcome. Thanks for the feedback!