Hi Guys,
Need help with this one plz ..
In these 2 formulas :
=SUM($AD$3:$AD$113)/SUM($AE3:$AE112)
=SUMPRODUCT(($A$3:$A$113=F119)*$AD$3:$AD$113)/SUMPRODUCT(($A$3:$A$113=F119)*$AE$3:$AE$113)
I need these formulas to not count the number 0 within the range as i'm trying to calculate an average. The zero means that there is no Data.
Anything i can add in this formula ?
Last edited by djsouljah; 10-30-2011 at 04:52 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks