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
- Check sum error - Guide
- Sum column if another column equals ✓ - Excel Forum
- How to convert column to row in notepad++ ✓ - Excel Forum
- Count the number of times a value appears in a column ✓ - Office Software Forum
- Display two columns in data validation list but return only one - Guide
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
