Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

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

Options
SidOrgane
SidOrgane
edited 12/09/19 in Archived 2017 Posts

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

Screen Shot 2017-08-25 at 6.02.57 PM.png

Comments

  • Shaine Greenwood
    Options

    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.

This discussion has been closed.