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!!
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives