identifying last month to sum up separate column

ally.boardman__101__

Hi, I have another query:

My worksheet includes a date column (mm/dd/yy) and I also have several other columns which include a 1 or 0 if certain criteria are met. What I need to be able to do is to identify if the month = LAST MONTH and if it does, to sum up, the values in each of the other columns separately. See the example table below if this helps:

Can anyone help, please?

Paul Newcome

Try something like this:

=IF(AND(MONTH(Date@row) = IF(MONTH(TODAY()) = 1, 12, MONT(TODAY()) - 1), YEAR(Date@row) = IF(MONTH(TODAY()) = 1, YEAR(TODAY()) - 1, YEAR(TODAY()))), SUM(This@row:[The Other]@row))