Sum if calculation

[D.Lopez]

Hello,

I am trying to sum the total amount values of row 19 (Total) that are past a certain month. What would I use if I want to sum totals for 5/1/2020 and beyond months? The issue I am having is the certain month is going to be variable so is going to vary. I attached a table for reference.

[Paul]

You can use SUMIF and specify a date or a cell containing the date (or a date that is the result of a formula, etc.).

Please Login or Register  to view this content.

Make sure your dates are being stored as dates, not text. For each of the date cells in row 2, I pressed F2 then Enter. I did the same for the row of totals.

[davsth]

Please give your thread an appropriate title as per the rules

for me the values in row 2 are text and not dates, this causes problems with the logic

If you put the date of interest in a cell (which could have a dropdown for you to select months

[D.Lopez]

=SUMIF(C2:N2,">="&B27,C24:N24) will work if the Total row stays on row 24. But how can I update the [Sum_Range] criteria if the Total row varies. (Ex: Total can be in row 23,24,25 etc). What function can I plug in the [Sum_Range] to help me solve this issue?

[CARACALLA]

C27=sumproduct((c2:n2>=b27)*(c6:n23))