LinkBack URL
About LinkBacks
How would I edit the below formula include AVERAGE..there is no averageif formula so I am not sure how to incorporate average into this formula.
=SUMIF(Data_By_Days_Applications!$F$3:$F$15,"="&F67,Data_By_Days_Applications!$G$3:$G$15)
Thanks
How would I edit the below formula include AVERAGE..there is no averageif formula so I am not sure how to incorporate average into this formula.
=SUMIF(Data_By_Days_Applications!$F$3:$F$15,"="&F67,Data_By_Days_Applications!$G$3:$G$15)
Thanks
There should be an =AVERAGEIF() formula:
Formula:
Please Login or Register to view this content.
If you are using Excel 2007.
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
Divide by CountIf with the same conditions.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
i am using excel 2003 and do not see an averageif formula there.
I tried the division by count if and it said I have too many arguments.
No, you don't have =AVERAGEIF() in Excel 2003, but you state in your profile that you are using Excel 2007. Try this instead:
Formula:Please Login or Register to view this content.
You can also use an "array formula" with AVERAGE in any version, e.g.
=AVERAGE(IF(RangeA=Condition,RangeB))
confirmed with CTRL+SHIFT+ENTER
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks