Sumif formula help


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!