Sum values from one column if another column equals x
Solved/Closed
Sarah
-
Dec 1, 2015 at 03:25 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Contributor Last seen September 6, 2024 - Dec 2, 2015 at 12:20 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Contributor Last seen September 6, 2024 - Dec 2, 2015 at 12:20 AM
Related:
- Sum one column based on another
- Excel sum column based on another column - Best answers
- Sum column based on another column - Best answers
- Excel column number - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- How to change account based in instagram - Instagram Forum
- How to extract data from excel based on criteria - Excel Forum
- Based on the values in cells b77 b81 ✓ - Excel Forum
1 response
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Dec 1, 2015 at 03:45 PM
Dec 1, 2015 at 03:45 PM
Put this in a column other than A or B as you will get a circular reference error.
=SUMIF(B:B,"X",A:A)
Hopefully that works. I've not had a lot of lucky with these questions lately.
=SUMIF(B:B,"X",A:A)
Hopefully that works. I've not had a lot of lucky with these questions lately.
Dec 1, 2015 at 05:08 PM
Dec 2, 2015 at 12:20 AM
Sarah just made your day! ;-)