Trying to add value in specific cell while using two column requirements
Our take
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Is there a way to Sumifs up to a certain column with multiple criteria?Hi everyone, I’m looking for a formula to sum all of the columns starting from a particular column up to a particular column. How do I best do that? On the data tab, Row 1 I have the following columns: A1 = date B1 = serial number C1 = customer name D1 = date 1, with the data being $ E1 = date 2, with the data being $ F1 = date 3, with the data being $ In a separate tab I have the same thing mirroring the data tab, but without the $, for the calculation what I intend to do is on E2, I want to say if $A2 = E$ 1, then sum all of D up to E column on the data tab provided that the value on B column of the data tab match B2 of the calc tab, and C column of the data tab match C2 of the calc tab. For F2, it would be the same thing, but sum column D up to column F instead of column E. I hope it makes sense. Thanks for your help! submitted by /u/botng [link] [comments]
- Index Match or Xlookup to return sum of row values based on matching two horizontal lookups?Ask: If E59:S59=E111 AND E60:s:60<-E112, give me the sum of E61:71,else return 0 What is the smoothest formula for this? I added in what I'm trying to do on the formula line. ChatGPT is less helpful with this than I am. I want to bundle by phase because our timesheet system doesn't allow me to pull a report by phase/task, only by person. I tried Xlookup but kept getting SPILL errors so I am at a loss. FTE1 is a different category and should not be included (PM, I can plug that as it's always in the same position). Thanks in advance for your help. https://preview.redd.it/yp4yzfn2rcxg1.png?width=2560&format=png&auto=webp&s=86eed1d2c8f3bb97c6d49592a0b1978d5f80f365 submitted by /u/Regular_or_BQ [link] [comments]