[SHORT Question] How to count only if both columns have values

[cjcmoney]

0 1
2 1
5 0
1 0
1 4
0 0


Ok so look at the data set above , two columns with numbers in them. I want to count the times a number greater then 0 appears in both columns.
So for above I want the answer to be a count of 2 because only twice does a number greater then 0 appear in both column- in this case 2nd row with (2,1) and the 5th row
with (1,4). The other occasions there is a 0 in at least one of the columns so it doesn't count them.

Any help would be greatly appreciated thanks!

[Pete_UK]

Try this:

=COUNTIFS(A:A,">0",B:B,">0")

Hope this helps.

Pete

[cjcmoney]

Works perfectly exactly what I wanted. Cheers!

[Pete_UK]

Glad to hear it - thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete