Sumifs for Entry Date & Job Number

Aflorcip_p4329

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

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)

Syntax

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.