Hi

=SUMPRODUCT(--(GroupRange=GroupName),--(ResultRange=ResultValue))


Arvi Laanemets


"benjam_in" wrote
in message ...

Right I've got a table that contains a lot of text that i need to
summarse in another table. Its really just two columns the first
contains a group name and the second a result. What I need to work out
is the number of times the result occurs for each group. But every work
sheet function I've entered fails.


--
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