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 Moderator Last seen September 6, 2024 - Dec 2, 2015 at 12:20 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Dec 2, 2015 at 12:20 AM
Related:
- Excel sum column if another column equals
- Sum column if another column equals - Best answers
- Sum of column if another column equals - Best answers
- How do i auto number a column in excel? ✓ - Excel Forum
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- Dash becomes date on excel ✓ - Office Software 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! ;-)