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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Counting Criteria in Cells in Multiple Ranges 4
Count Unique accross mulitple columns 3
COUNT IF Help with multiple conditions 4
Comparing data from two columns 2
Count if with multiple column criteria 7
Counting occurance of >0 in two columns 3
Mulitiple Count of occurrences in different columns 3

Top