Sum values from one column if another column equals x
Solved/Closed
Sarah
-
Dec 1, 2015 at 03:25 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Dec 2, 2015 at 12:20 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Dec 2, 2015 at 12:20 AM
Related:
- Sum column if another column equals
- Sum if equal to another cell - Best answers
- Excel sum of column where another column equals - Best answers
- Vba find column by name ✓ - Excel Forum
- How to convert row to column in notepad++ ✓ - Excel Forum
- Auto serial number in excel based on another column ✓ - Excel Forum
- Count the number of times a value appears in a column ✓ - Office Software Forum
- Excel copy column from one sheet to another automatically - 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! ;-)