Help with excel formula

[ss]

O

That still gives thr wrong answer. In the cell I require the answer I have =AVERAGEIF(C3:AL3,"%",C18:AL18)

[GB]

If you change it to: =IF(O18>0,P18/O18,"")

[ss]

I have no idea it takes me to the image.

[ss]

Maybe this will help (I cant really understand it) Apparently my formula is correct but for, and I quote:

"The only way to get to 58.75 is if one of the % columns contains a 0.

Looks like you are using formulas to calculate the percentage and format away zero values, but they are still in the cells. If you use formulas to calculate the percentage column, return a blank instead of a zero to have it ignored in the average.

Just thinking maybe its the cell I want the average in that he is referring to?

[ss]

Thats it! spot on, problem solve.

Thank you all

[newshound]

Also, if the formulae get complicated it is often worth adding one or more intermediate columns with simpler formulae in them. Easier to understand and debug. You can always hide them when it's working properly.

[stuart noble]

That's what I love about spreadsheet queries. There's always a solution that works and everybody moves on (unlike this place!)

[Jim Newman]

Happy to help The only suggestion I would make is that you amend it to 'fix' the check against row 3, by using =IFERROR(AVERAGEIFS(C18:AL18,$C$3:$AL$3,"%",C18:AL18,">0"),"") as then you could set it for the first row, and then drag down to complete the rest of the column.