Sum certain values in a column
Closed
JB
-
Feb 24, 2012 at 08:25 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 24, 2012 at 10:02 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 24, 2012 at 10:02 PM
Related:
- Sum certain values in a column
- Display two columns in data validation list but return only one - Guide
- How to delete column in word - Guide
- How to sum values based on criteria in another column in excel ✓ - Excel Forum
- Tweetdeck remove column - Guide
- Vba select column by name ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 24, 2012 at 10:02 PM
Feb 24, 2012 at 10:02 PM
data is like this with column headings
hdng1 hdng2
AAA 13
BBB 6
CCC 20
BBB 4
in B2 type or copy this formula
=SUMPRODUCT(($A$2:$A$5=A2)*($B$2:$B$5))
copy B2 down
hdng1 hdng2
AAA 13
BBB 6
CCC 20
BBB 4
in B2 type or copy this formula
=SUMPRODUCT(($A$2:$A$5=A2)*($B$2:$B$5))
copy B2 down
