how to sum highest ranking values meeting criteria within a limit?

[QuantumPion]

Here is a more detailed explanation. I need a function that will sum the n largest values in an array, where the values are less then x and are not #N/A, meet a criteria in a seperate array, and where the total of the sum is less then or equal to y. How can I do this? Thanks.

For example, here is my data:

name   type   value

alpha     g     1
bravo           5
charlie   g     2
delta     g     #N/A
echo            3
foxtrot   g     7

I want a function that will find the sum of the largest two values that are "g" that add to 8 or less. So the output would look like:

name   value
alpha    1
foxtrot  7

sum:     8