How do I use "sumif" for cells ">0" across multiple ranges?

P

PKB

I would like to sum cells where they are greater than zero but are across
multiple ranges. Ultimately this is to get an average value therefore I
would need to do the same with a count as well.

There may be a quicker way to get the average rather than using a sum and
count but I'm still curious as to how a sum an count can be used to achieve
this.

Would be grateful for any advise.
 
E

Eduardo

Hi
An example will be great by anyway to count figures greater than

=COUNTIF(A1:E1,">0")

To sum figures greater than 0

=SUMPRODUCT(--(A1:E1>0),A1:E1)
 

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

Enter value zero into all cells in multiple ranges? 4
SUMIF w/multiple conditions 5
How do I add cells by highlighting them? 2
... I need some help with a formula ... 3
Help with Averages/Sums of values returned from IF function 6
Countif across multiple non-adjacent cells 2
VIEWING adjacent/nonadjacent cells or cell ranges in Excel 2007 1
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1

Top