LinkBack URL
About LinkBacks
You can also use an "array formula" with AVERAGE in any version, e.g.
=AVERAGE(IF(RangeA=Condition,RangeB))
confirmed with CTRL+SHIFT+ENTER
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