Cumulative Column Query for Sheet A and Sheet B

Khasim

Hello,

I have Sheet A, which contains a column with work dates that have been inspected. I would like to create a cumulative column in Sheet B based on the maximum date from Sheet A. However, it appears that the current setup is cumulating all the dates in Sheet B instead of considering the maximum date from Sheet A. I have attached screenshots of Sheet A and Sheet B for your reference, along with the formula I am using.

Sheet A

Sheet B

Formula: =IF(INDEX({Sheet A Date Range 4}, MATCH([Work Date Inspected Piles]@row, {Sheet A Date Range 4}), 0) <= MAX({Sheet A Date Range Range 4}), SUMIFS(Piles:Piles, Row:Row, @cell <= Row@row), " ")

Paul Newcome

You'll need to use an IF statement that reads along the lines of IF the MAX({date}) is greater than or equal to [Date Column]@row, perform calculation.