SUMIFS - Criteria person's Name & Date to SUM 3rd column with numerical value.

SidOrgane

Purpose: To sum the hours worked per person for a given week.

COLUMN 1: Name

COLUMN 2: Date

COLUMN 3: Hours (Integer Format)

2 independent SUMIF formulas working, but not SUMIFS together.

FORMULA 1:  =SUMIF(Name:Name; "Sid Organe"; [Tsk-Hrs]:[Tsk-Hrs]) Working

FORMULA 2: =SUMIF(Date16:Date46; IFERROR(WEEKNUMBER(@cell); 0) = 33; [Tsk-Hrs]16:[Tsk-Hrs]46) Working

FORMULA 3: =SUMIFS(Date16:Date48; IFERROR(WEEKNUMBER(@cell); 0) = 33; [Person]:[Person]; "Eric Savioe"; [Tsk-Hrs]:[Tsk-Hrs])  UNPARSEABLE

IS THERE ANYONE THAT CAN HELP ME WITH THIS?

Thanks

Sid

Shaine Greenwood

Hi Sid,

Looks like you're referencing a column named Person, but I believe your column name is Contractor. Try changing this to ...; [Contractor]:[Contractor]; "Eric Savioe";...

I'm also noticing that your sum range is at the end, SUMIFS (unlike SUMIF) needs the range to be at the beginning of the function, details on this are available in the SUMIFS functions article: https://help.smartsheet.com/function/sumifs

Let me know if it still doesn't work after trying the above.