Sumif formula help

Barbara Nicholas

Hello,

I may be on the rite track with sumifs but have not had luck in cracking it.

I am looking to sum 3 things. The total of the value associated to a months forecast. the total marked as complete in that same month in a different column and then the difference between those.

I have 3 columns to reference date for forecast, date for completion and a number column showing the value.

Sample of the format I am referencing is below. I would like to be able to create this for each month in a calendar year to produce these 3 metrics across the year. Any help is very much appreciated! I am consistently getting incorrect arguments and may not be on the rite path.

Barbara Nicholas

That worked perfectly thank you very much Paul!

Paul Newcome

Try something along the lines of...

=SUMIFS(Value:Value, Complete:Complete, ISDATE(@cell))

=SUMIFS(Value:Value, Forecast:Forecast, AND(IFERROR(MONTH(@cell, 0) = 4, IFERROR(YEAR(@cell), 0) = 2020))

Barbara Nicholas

That worked perfectly thank you very much Paul!

Paul Newcome

Happy to help. 👍️