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

--
benjam_i
-----------------------------------------------------------------------
benjam_in's Profile: http://www.excelforum.com/member.php...fo&userid=3629
View this thread: http://www.excelforum.com/showthread.php?threadid=56074

Hi

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


Arvi Laanemets


"benjam_in" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>

Try the pivot table wizard. This is a great way to summarize and count
when you've got multiple groups.

- John


benjam_in wrote:
> 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

need to apply it to the second table using the data from the first


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

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

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

I have responded with an example on OzGrid. No need to post all over the
place.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"benjam_in" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>