Formula for Quarterly Revenue
Hello,
I have been attempting to calculate the projected revenue for the quarters. I am at a loss. Just need to find the revenue for each quarter. I provided some of the information that I am looking at.
The formula I used is returning a 0; I fee like I'm close but just can't seem to get it.
=SUMIF([Weighted Forecast]19:[Weighted Forecast]25, "2020  Q1", [Expected Revenue Quarter]19:[Expected Revenue Quarter]25)
Best Answer

Hi @Michele Thomas,
If you want to sum the cells in the Weighted Forecast column that have a value of 2020  Q1 in the Expected Revenue Quarter columns then you'll need to flip the range and sum_range around. Your formula should look something like this:
=SUMIF([Expected Revenue Quarter]19:[Expected Revenue Quarter]25, "2020  Q1",[Weighted Forecast]19:[Weighted Forecast]25)
If needed, more information on the SUMIF syntax can be found in our help article: https://help.smartsheet.com/function/sumif
Answers

Hi @Michele Thomas,
If you want to sum the cells in the Weighted Forecast column that have a value of 2020  Q1 in the Expected Revenue Quarter columns then you'll need to flip the range and sum_range around. Your formula should look something like this:
=SUMIF([Expected Revenue Quarter]19:[Expected Revenue Quarter]25, "2020  Q1",[Weighted Forecast]19:[Weighted Forecast]25)
If needed, more information on the SUMIF syntax can be found in our help article: https://help.smartsheet.com/function/sumif

Thank you so much @Alejandra Worked Perfectly!!