Forum Discussion
Solved
Formula with % and averages???
Hey guys, I'm hoping for a solution to a wee problem... I'm looking for the average of a number of cells. There is a formula in each of these cells, some cells are populated with data and some ...
Alison Flynn , that could be
=SUM(FE6,HJ6,JO6,LT6,NY6,QD6,SI6)/INDEX(FREQUENCY((FE6,HJ6,JO6,LT6,NY6,QD6,SI6),0),2)
Source is here https://www.exceldashboardtemplates.com/how-to-averageif-excluding-zeros-and-blanks-for-non-contiguous-ranges-in-excel/
Alison Flynn , that could be
=SUM(FE6,HJ6,JO6,LT6,NY6,QD6,SI6)/INDEX(FREQUENCY((FE6,HJ6,JO6,LT6,NY6,QD6,SI6),0),2)
Source is here https://www.exceldashboardtemplates.com/how-to-averageif-excluding-zeros-and-blanks-for-non-contiguous-ranges-in-excel/
Hi Sergei,
You have done it again! That works perfectly. Thank you so much, much appreciated.
Hi Alison,
You are welcome. Formula which Twifoo suggested also works if only you have blank or zero cells. If you have empty strings in your cells, e.g. returned by something like =IF(<A>,"",number), you may use it changing 0 on "". If you need to check both the variant could be .../((LEN(FE6)>0)+...