Home |
Search |
Today's Posts |
|
UK diy (uk.d-i-y) For the discussion of all topics related to diy (do-it-yourself) in the UK. All levels of experience and proficency are welcome to join in to ask questions or offer solutions. |
|
LinkBack | Thread Tools | Display Modes |
#1
Posted to uk.d-i-y
|
|||
|
|||
Help with excel formula
I know wrong newsgroup but trying to get something I can understand So
hoping one of you guys understands excel formulas. Using this formula: =AVERAGEIF(C3:AL3,"%",C18:AL18) What thats doing for me is giving me the number of cells that have a number in them under the column heading % and that works fine. Problem is if the cells in C18:AL18 are zero it picks up the zero and counts that in as well. Even if I change the cells to dont show a zero show a blank it is effectively still there. Can anyone help to adjust the formula for me. This is the answer in english but how the heck do I do it. ".....If you use formulas to calculate the percentage column, return a blank instead of a zero to have it ignored in the average...." So this needs to change: =IFERROR(G18/F18*(100),"") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel and Excel Services 2010 | UK diy | |||
OT; Excel help please | UK diy | |||
OT; MS Excel | UK diy | |||
Converting Excel 2007 Nested "If" Statement to Excel 2003: Overcom | Electronic Schematics | |||
OT MS Excel | UK diy |