Excel- how to sum specific data
Closed
Fessi
Posts
3
Registration date
Wednesday January 29, 2014
Status
Member
Last seen
January 30, 2014
-
Jan 29, 2014 at 02:25 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 31, 2014 at 06:46 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 31, 2014 at 06:46 AM
Related:
- Excel- how to sum specific data
- Transfer data from one excel worksheet to another automatically - Guide
- Excel date format dd.mm.yyyy - Guide
- How to enable vba in excel - Guide
- How to take screenshot in excel - Guide
- How to change author in excel - Guide
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Jan 31, 2014 at 06:46 AM
Jan 31, 2014 at 06:46 AM
your region names have an unnecessary space at the end. this gives probklem
try this formula
=SUMPRODUCT((TRIM(A2:A17)="Lombardia")*B2:B17)
try this formula
=SUMPRODUCT((TRIM(A2:A17)="Lombardia")*B2:B17)
