Excel- how to sum specific data [Closed]

Report
Posts
3
Registration date
Wednesday January 29, 2014
Status
Member
Last seen
January 30, 2014
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

how can I sum only specific cells together?

Column A - Regions
Marche
Puglia
Lombardia
Emilia-Romagna
Lombardia
Puglia
Trentino-Alto Adige
Sardegna
Molise
Campania
Sicilia
Piemonte
Lombardia
Calabria
Sicilia
Calabria

Column B - Sales
160,994
463,251
405,626
542,009
451,468
205,191
31,332
1,162,856
2,067,917
338,602
56,074
205,152
259,526
615,021
114,862
1,306,420

I need in B70 to get only the sales for f.e. Lombardia.
Who can help me?

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
your region names have an unnecessary space at the end. this gives probklem

try this formula

=SUMPRODUCT((TRIM(A2:A17)="Lombardia")*B2:B17)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!