Question

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

Jimmy

Hi,

I have a sheet as below

A-Column B-Column

Germany 2.25
ITALY 3.25
USA 4.00
Germany 7.25
USA 1.25
Germany 7.02
Germany 6.02

Over 50 records

I want to get the total amount based on A-Column's country name. In fact, I
know that sorting A-Column by country name firstly and then use sum to get
the total.

However, I do not want to use this way.

Have any formula can do it.

Thanks
Jimmy
 
Hi Jimmy

=SUMIF($A:$A,"Germany",$B:$B)
You could instead, put Germany in a cell, say D1, Italy in E1 and USA in
F1
Then in D2 enter
=SUMIF($A:$A,D1,$B:$B)
copy across through E2:F2 and you will have your sums under each country
name
 
Hello
Either
=SUMIF(A1:A50,"Germany",B1:B50)
or
=SUMPRODUCT((A1:A50="Germany")*(B1:B50))

HTH
Cordially
Pascal
 
Hi, Roger

Thanks
Jimmy

Roger Govier said:
Hi Jimmy

=SUMIF($A:$A,"Germany",$B:$B)
You could instead, put Germany in a cell, say D1, Italy in E1 and USA in
F1
Then in D2 enter
=SUMIF($A:$A,D1,$B:$B)
copy across through E2:F2 and you will have your sums under each country
name
Click to expand...
 
Back
Top