Excel- how to sum specific data
Closed
Fessi
Posts
3
Registration date
Wednesday 29 January 2014
Status
Member
Last seen
30 January 2014
-
29 Jan 2014 à 02:25
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 31 Jan 2014 à 06:46
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 31 Jan 2014 à 06:46
Related:
- Excel- how to sum specific data
- How to copy data from one excel sheet to another - Guide
- How do i find a specific video on youtube - Guide
- Export data from excel - Guide
- Excel move data from one sheet to another - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
31 Jan 2014 à 06:46
31 Jan 2014 à 06:46
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)
