Trying to add value in specific cell while using two column requirements
Hi all, very new at this. I'm trying to calculate the amount of credits taken for each required class passed. I've tried some formulas along the lines of:
=COUNTIFS(Table1[Req for degree],"Y",Table1[Grade],"Passed", SUM(C:C))
but using the whole column usually just gets me adding up all the credits again.
I've been able to get the number of required classes /taken/ but trying to sum the amount of credits from each of those classes has been giving me trouble. I'm not even sure what to look up to solve this! I'm assuming I might need an XLOOKUP into a SUM?
Any help would be appreciated, thanks.
Edit:
Solved! Thanks guys! Ended up doing:
=SUMIFS(Table1[Credits],Table1[Grade],"Passed",Table1[Req for degree],"Y")
[link] [comments]
Want to read more?
Check out the full article on the original site