Suming Amounts if numbers match
Options
Samuel Dowdy Jr.
✭✭✭✭✭
=SUMIFS([Revenue Projection]25:[Revenue Projection]36, [Month - Count]25:[Month - Count]36, >=[Month - Count]7)
I want to say sum revenue amounts if the months are greater than the current month (8). The problem I see is its only adding months 8 & 9 and not 10-12.
Answers
-
Are you able to provide a screenshot of the data for reference?
-
-
How exactly are you populating the month numbers?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!