Count Formula Needed

[steve472]

I have a table, A1:B20. In column A I have names, Chris, Steve and Mat. In Column B I have differing values associated with each name. For example:

Chris - £20
Steve - £45
Mat - £10
Steve - £45
Chris - £25
Mat - £30
Mat - £15

I need a count formula that adds up the total value assigned to each person. So for the above example the result would be:

Chris - £45
Steve - £90
Mat - £55

Can you help?

Steve

 

[jeffreybrown]

You could try one of...

=SUMIF(A1:A7,A9,B1:B7)

=SUMPRODUCT(--(A1:A7=A9),B1:B7)

A9 holds Chris

 

[wolverineb]

This should be a straightforward SUMIF

 

[meldoc]

Hello

Try.

Excel Workbook
	A	B	C	D	E
1	Chris	20		Chris	45
2	Steve	45		Steve	90
3	Mat	10		Mat	55
4	Steve	45
5	Chris	25
6	Mat	30
7	Mat	15
Sheet1

 

[Norie]

How about Data>Pivot table...?

 

[Robert Mika]

in
C1 to C3
Chris
Steve
Mat

in D1 copied down:
=SUMIF($A$1:$A$7,C1,$B$1:$B$7)