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

Good to hear it. Thanks for marking the thread as Solved.

Did you know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of any post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete