assuming that your data is on Sheet2!a2:b100

=sumproduct(--(a2:a100="group")*(b2:100))

hth
regards from Brazil
Marcelo

"benjam_in" escreveu:


Tried that didnt seem to work, got #NUM! error. Both the group and the
results are text.


--
benjam_in
------------------------------------------------------------------------
benjam_in's Profile: http://www.excelforum.com/member.php...o&userid=36295
View this thread: http://www.excelforum.com/showthread...hreadid=560742