count for multiple conditions in multiple columns

  • Thread starter Thread starter tturklsu
  • Start date Start date
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?
 
XL-2007
=COUNTIFS(A1:A10,"<>0",B1:B10,"<>0")

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