So I need to Average the cells I7, I9, F12:F18, M12:M18 in Cell G2
Cell F12 is an Average of its respective cells bellow. (and so forth)
NRT will = 1
N/O will = 0
I have cells F12:F18, M12:M18 indicate NRT in the cells when selected I would like N/O to also be displayed however it comes across as 0.
How do I avoid the #DVI/0! Errors and get the averages to calculate appropriately.
See the attached sample.
Thanks
Array formula confirm Control+Shift+Enter
=IFERROR(AVERAGE(IF(ISNUMBER($E$33:$E$429),IF($A$33:$A$429=A12,$E$33:$E$429))),"")
Last edited by RobertMika; 03-02-2014 at 05:57 PM.
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks