Hi Timmy

=SUMPRODUCT(--(alpha=A1),--(beta=B1)*beta)

should give you what you're after

Cheers
JulieD

"Timmy Mac1" wrote in message
...

Tried this yesterday and have only just realised that my message didn't
actually load up.

I have a column range of IDs named ALPHA alongside a column range of
values named BETA.

I want to find out, for a given ID in cell A1, both the number of
values which exceed a given value in B1, and the aggregate of those
values.

I can get the number of values by the following formula....

=SUMPRODUCT((ALPHA=A1)*(BETA=B1))

However I'm struggling to get an aggregate total of the relevant
values. I was kind of thinking ..

=SUMPRODUCT((ALPHA=A1)*(BETA=B1)*(BETA)) would do the trick but it
doesn't , I only get a return of #VALUE :(

Can anyone help me please ? :)


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile:
http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=345976