Count, Countif, Sumif??

B

benjam_in

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
 
A

Arvi Laanemets

Hi

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


Arvi Laanemets
 
J

John Michl

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

- John
 
B

benjam_in

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

Marcelo

assuming that your data is on Sheet2!a2:b100

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

hth
regards from Brazil
Marcelo

"benjam_in" escreveu:
 
B

Bob Phillips

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