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:
- Excel sum column if another column equals
- Excel sum column based on another column - Best answers
- Sum column based on another column - Best answers
- Excel column number - Guide
- How to delete a column in word - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to extract specific data from a column in excel - Excel Forum
- How to copy data from one excel sheet to another - Guide
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! ;-)