If you were using Subtotal, then the Sumproduct would provide the
answer, as in D1 enter:

=SUMPRODUCT(($A$1:A$99=C1)*(B$1:B$99))

which would provide the total of the item in C1, and when
formula-dragged down to cover all items entered in column C will total
each item for you.

Adjust the A1:A99 and B1:B99 to your data.

If you were after the 'Maximum' value from the range please let me
know.


rmellison Wrote:
I have a list of parameter names and a corresponding list of values;
there
may be ten or so of each of the parameters within the list. I have been
using
SUBTOTAL(4,range) to find the maximum of a parameter when filtered
using
autofilter, and up until now this has been fine.

Now I find myself needing to do a similar thing for an unfiltered list
which
is on another worksheet. I want to be able to find the maximum of all
the
values corresponding to all entries of a particular parameter within a
list.
I suspect that the way to do it is using VLOOKUP or INDEX/MATCH to find
an
array of the numbers I want, and then finding the maximum of that
array, but
so far I haven't cracked it....

Any suggestions gladly appreciated...


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=489753