Formula to count different collumns, error.

I am trying to count tree different collumns with this formula: =COUNTIF(L4:L11+P4:P11+R4:R8;">0") ,but its showing error. I dont know why. Because there are intersected cells that i dont want to COUNT "L4:R8" won't work

How to fix this formula?

Now i see my mistake,


Thank you Marvin

Now I am trying to use this same formula but with "AVERAGEIF" and the result i am getting is wrong. Probably I canīt add using average, so AVERAGEIF(L4:L11,>0)+AVERAGEIF(P4:P11,">0") wont work.

How to solve this problem?

You can use AVERAGEIFS where you have multiple conditions, but I don't think that is what you want, as the conditions are ANDed together, so that all cells on a corresponding row would have to be greater than zero to be included in the average calculation.

Perhaps you need three SUMIF functions added together, and the result to be divided by three COUNTIF functions added together, similar to the formula in Post #2.

Hope this helps.

Pete

Sorry, I didn't give you the formula:

=(SUMIF(L4:L11,">0")+SUMIF(P4:P11,">0")+SUMIF(R4:R11,">0")) / (COUNTIF(L4:L11,">0")+COUNTIF(P4:P11,">0")+COUNTIF(R4:R11,">0"))

Hope this helps.

Pete

Good idea Pete.

The formula worked,

Thank you