Sumifs syntax help
trying to get a sum for the number of OT sessions for each student in a given week
not sure what's wrong with my formula
=SUMIFS([Todays Week ]@row, {Week Number}, [Student Code]@row, {OT Student Code}, {OT Sessions},=>1)
I'm trying to sum the number in the OT session column of a separate sheet if the week number matches matches todays week column and the student code in my row matches with the student code in the separate sheet. I dont think i need the =>1 in the sessions count because if there's a 0 or no valuse the session log it should still calculate but I couldn't get it to work and I thought it needed some kind of criterion there
thanks
Best Answer

Hi @Dell55, there is something weird in your formula (the arguments being jumbled up)  the first argument of SUMIFS is the range of cells you are trying to sum up and  I guess it's not the [TODAY Week]? To me the formula should rather be:
=SUMIFS({OT Sessions}, {Week Number}, [Todays Week ]@row, {OT Student Code}, [Student Code]@row)
Hope it makes sense but pls get back if unclear
Regards
Vojtech
Answers

Hi @Dell55, there is something weird in your formula (the arguments being jumbled up)  the first argument of SUMIFS is the range of cells you are trying to sum up and  I guess it's not the [TODAY Week]? To me the formula should rather be:
=SUMIFS({OT Sessions}, {Week Number}, [Todays Week ]@row, {OT Student Code}, [Student Code]@row)
Hope it makes sense but pls get back if unclear
Regards
Vojtech

Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 61 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!