LinkBack URL
About LinkBacks
I think averageifs can accomplish that though I haven't used that function yet but if you have 2007 or later excel it is available. Give it a try and see.
I think averageifs can accomplish that though I haven't used that function yet but if you have 2007 or later excel it is available. Give it a try and see.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Unfortunately, no, it will not help. AVERAGEIFS takes care of multiple conditions, but single average_range that in AVERAGEIFS should be the same size as conditions_range.
While I need 1 conditions_range that is only 1-column-width and 1 average_range that is 5-columns-width.
Last edited by Shurov; 12-11-2014 at 08:39 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks