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

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.

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

Simplest way is to have multiple SUMIFs/COUNTIFs.

--
__________________________________
HTH

Bob

"PKB" wrote in message
...
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.

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

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:E10),A1:E1)

"PKB" wrote:

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.