Following on from my previous post!
This is the formula I am using to find the average.
=SUM(T4,H4,L4,P4,X4,AB4,AF4,AJ4)/INDEX(FREQUENCY((T4,H4,L4,P4,X4,AB4,AF4,AJ4),0),2)
It is generating #Div/0! when all the referenced cells are blank, 0 or contain text.
Help please!
why are you using frequency? surely the average is
SUM(T4,H4,L4,P4,X4,AB4,AF4,AJ4)/8
oh i see
well if all text or 0 you will get #div/0 to hide it put
=IF(SUM(T4,H4,L4,P4,X4,AB4,AF4,AJ4)=0,0,SUM(T4,H4,L4,P4,X4,AB4,AF4,AJ4)/INDEX(FREQUENCY((T4,H4,L4,P4,X4,AB4,AF4,AJ4),0),2))
Last edited by martindwilson; 11-15-2012 at 06:41 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks