Try this...

=SUMPRODUCT(MAX((A1:A1000="LC05XGE")*B1:B1000))

Reset the maximum row from the 1000 I used in my example to the maximum row
you ever expect to fill data in. Also, you may want to consider using a cell
to hold the lookup value (LC05XGE) and replace the "LC05XGE" with the cell
address instead.

Rick



"Jay" wrote in message
...
Hi,

I have two columns - 'Key' (text, col A) and 'Forecast' (number, col B).

I have several rows for each 'Key' value, but the number of rows *varies*.

How do I (in one function in col C) calculate the maximum value for each
'Key'?

i.e If I have 16 rows all with the 'Key' value LC05XGE - what is the
maximum 'Forecast' value in the corresponding 16 'Forecast' values?

Any help greatly appreciated......Many thanks,

Jason