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
Help Article Resources
Check out the Formula Handbook template!