Sum values from one column if another column equals x
Solved/Closed
Sarah
-
1 Dec 2015 à 15:25
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Moderator Last seen 6 September 2024 - 2 Dec 2015 à 00:20
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Moderator Last seen 6 September 2024 - 2 Dec 2015 à 00:20
Related:
- Excel sum column if another column equals
- Sum column if another column equals - Best answers
- Excel sum of column where another column equals - Best answers
- Excel column to number - Guide
- Excel count occurrences of string in column - Guide
- How to delete column in word - Guide
- Auto serial number in excel based on another column ✓ - Excel Forum
- Excel mod apk for pc - Download - Spreadsheets
1 response
RayH
Posts
122
Registration date
Tuesday 31 August 2010
Status
Contributor
Last seen
20 June 2016
26
1 Dec 2015 à 15:45
1 Dec 2015 à 15:45
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.
1 Dec 2015 à 17:08
2 Dec 2015 à 00:20
Sarah just made your day! ;-)