Need to Sum Values Based on Common Criteria and then pull out the top values...

[nyiballs]

Criteria 1 Criteria 2 Value
A # 5
A $ 2
A % 6
A # 3
A ! 4
A % 7
B $ 2
B $ 3
B # 6
B @ 8
B @ 5
B ! 7

See above for an example... I want to pull the top 3 SUM of the Values in which the first column equals B. So... for the first large Value, I want it to know that the output should be "@" and the value is 13, because for Criteria 1 = B, Criteria 2 "@" has the highest sum of values. Next, for large 2, I want it to know to pull "!" because that value is 7, which is larger than # (6) and $ (5), etc.

I want it to be completely dynamic, so I can tell it to look within whichever Criteria 1 I want, and it will pull Criteria 2 and the sum value.

Any ideas?

[nyiballs]

I want to add, that let's assume we have thousands of lines of data...

[nyiballs]

I imagine we can write a Macro that tells it to look at the first two columns and sum the third column based on commonality?

[AlKey]

Deleted. post totally irrelevant.

[JeteMc]

I am going to suggest a pivot table solution, with criteria 1 as the report filter. Here is a file that uses the data you supplied applied to a pivot table:
Pivot Table Top Three.xlsx
I don't remember whether or not the 2007 version allows slicers, but if so they might be more convenient than the report filter.
Let me know if you have any questions.

[hemesh]

assuming your data is in A1 to C12 then In I1 type # in I2 $ in I3 % in I4 ! In I5 @

in E1 copy paste below hold control and shift together then hit enter to make it array formula and drag to right to 3 columns if you drag to 4th column you will get 4th largest value
=LARGE(SUMIFS($C$1:$C$12,$B$1:$B$12,$I$1:$I$5,$A$1:$A$12,"B"),COLUMNS($A$1:A1))

[nyiballs]

Good thought hemesh, except instead of 4 variables, let's say there are 1,000 variables...

[hemesh]

please upload a sample file