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
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!