I'm working on a spreadsheet and I need help figuring out how to make a function that will conditionally sum the largest N values in a column. This'll be better explained by an example... here's what the columns would look like:
Now, I need a formula that will sum the values from column B as long as they have an "F" in column A, but only sum the largest 3 of them.
The closest I've been able to get is =SUMIF(A1:A9,"F",B1:B9), but that only gives me a sum of all the B values that have an "F" in column A. I was trying to use LARGEST along with it, but it uses arrays and SUMIF doesn't accept arrays (I don't think).
Thanks!
Bookmarks