Sumifs for Entry Date & Job Number


I am trying to create a cumulative count of all Piers Completed through a given date respective to a specific job (Job Number) below is the syntax I have so far but my argument is coming back incorrect...

=SUMIFS([Job #]:[Job #], [Job #]@row, [Piers Completed]:[Piers Completed], [Entry]:[Entry], <[Entry]@row)

Entry = Date of work


  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    edited 01/03/22

    You might need to move your range to the beginning of the formula:

    =SUMIFS([Piers Completed]:[Piers Completed], [Job #]:[Job #], [Job #]@row, [Entry]:[Entry], <[Entry]@row)


    SUMIFS( range,  criterion_range1, criterion1, [ criterion_range2, ​criterion2​... ])

    range — The group of cells to sum, assuming they meet all criteria.

    criterion_range1 — The group of cells to be evaluated by the criterion.

    criterion1 — The condition that defines which numbers to add; for example: 15, "Hello World!", or >25.

    criterion_range2, ​criterion2​... —[optional] Additional ranges and criteria to have evaluated.

    You might need an equal sign before [Job #]@row as well. Try it and see.


    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!