Formula for Quarterly Revenue

Michele Thomas

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)

Alejandra

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

Alejandra

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

Michele Thomas

Thank you so much @Alejandra Worked Perfectly!!