SUMIFS Returning Zero?
I am trying to sum all hours that meet a certain criteria (match the lookup column/project ID).
My Formula:
=SUMIF({0  Affiliate TESS HOURS}, [LOOKUP COLUMN]@row, {0  Affiliate TESS Lookup})
{0  Affiliate TESS HOURS} > references "Entered Hours"
{0  Affiliate TESS Lookup} > References "Lookup Column"
Formula is in the last column
Source Sheet
I tried even to multiply "entered hours" by 1 to ensure "hours" is counted as a number. I referenced both of those two columns at one point and neither summed to anything other than 0.
I confirmed by COUNTIF that there are many rows that match the lookup column so that shouldnt be the issue?
Answers

At one point, I also wanted the criteria for "trailing hours" only (in last month) but gave up on adding the second condition.

Try switching the ranges in your formula. The syntax for SUMIF has the range to sum as the last range, so the Hours range should be in the last bit.
To add multiple range/criteria sets, you will need to switch over to a SUMIFS which does have a different syntax than SUMIF.
=SUMIFS(range_to_sum, 1st_criteria_range, 1st_criteria, 2nd_criteria_range, 2nd_criteria, ..........................)

I switched it to this and its still giving me zero hours:
=SUMIF({0  Affiliate TESS TO}, TO@row, {0  Affiliate TESS HOURS})
(the match is the TO)

Is it that there should be a match criteria for the TO@row? I want it to be whatever matches {0  Affiliate TESS TO}

And yes, that is it. Needed an = sign for the criteria.
Here is the formula that worked:
=SUMIF({0  TESS Affiliate DSC TO}, =[ DSC TO]@row, {0  Affiliate TESS Entered Hours})

It looks like you're not getting a match on the TO portion. Are you able to provide a screenshot showing the sheet with the formula alongside the source data where there should be a match that generates a sum?
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!