array formula with divisions
A ¦ B
2 ¦ 10
3 ¦ 12
4 ¦ 16
I'm looking for an array formula which:
1)checks for rows whose value in column B is smaller than 15
2)for the applicable rows it divides value from column "B" by the one in "A"
3)in the end it shows average of all divisions
What I came up with:
followed by Ctrl+Shift+Enter
is quite complicated.
Is there any simpler way to perform this operation without having to repeat the "<15" condition? I'm trying to find a way to facilitate calculations for tables with more conditions.
Thanks for any suggestions
Last edited by matt_pl; 10-09-2006 at 11:13 AM.
I don't think you are going to find a less complicated way, unless you don't want to have to hit Ctrl-Shift-Enter when you're done...
Then you could use the SUMPRODUCT formula as follows...
And no Ctrl-Shift-Enter to do...
Hope that helps...
This has opened whole new possibilities now.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1