Sorry, B1:B10 should be B3:B500.
Jason
"Jason Morin" wrote:
How about...
=SUM(IF(A3:A500LARGE(A3:A500,6),B1:B10))
Array-entered.
HTH
Jason
Atlanta, GA
"Phillycheese5" wrote:
Hi,
I have a formula that finds and sums the top 5 values in column A for a
given range:
SUM(LARGE($A$3:$A$500,ROW(INDIRECT("1:5"))))
Now I want to use the top 5 criteria in column A to sum corresponding
cells in B.
I tried incorporating into this formula:
SUM(IF(A3:A500=LARGE(A3:A500,ROW(INDIRECT("1:5"))) ,B3:B19))
but that's not it.
Any help would be appreciated!
Phillycheese5
--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=378092