Hi Everyone, I am currently trying to create a formula in R3 which enables me to Sum the figures in the table below based on the the text in value C and the date criteria in row 2. In this example I would like to sum values that are tied to the text "Forecast" for months that fall before the current Month. So the forecast YTD Revenue in Column R should equal $97,706. Any help would be greatly appreciated. Picture attached below for reference. Thank You!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sumif/Sumif Formula with multiple criteria
- Thread starter acool
- Start date
Hi @Fluff-previous formula has been marked as completed. I wasn't sure if the text "Forecast" now affects the formula as I am now receiving a value error when applying the formula to the current scenario. I am attaching a photo of the error/formula below (Formula in R3 is now yielding value error). Thank You!
Upvote
0
Unfortunately, I'm unable to download XL2. However, I think I figured out the issue. It was surround a relative vs. Absolute cell reference. After changing the references, I was able to get the formula to work. Thank you for your help!
Upvote
0
Similar threads
- Question
