count for multiple conditions in multiple columns

T

tturklsu

I have two columns of numbers and i want to count how many times both columns
have a nonzero number on the same row. What is the formula to do this?
 
T

Teethless mama

XL-2007
=COUNTIFS(A1:A10,"<>0",B1:B10,"<>0")

All versions
=SUMPRODUCT(--(A1:A10<>0),--(B1:B10<>0))
 
Top