Forum Discussion
Sumif formula not working
This is the formula i am using in my excel =SUMIF(Sales!,Scenario_1,TableSales[Quarter_1]) which my professor told us to use. and when i press enter it says "there is a problem with this formula,... ...
zackvillani First try without the exclamation mark after Sales as that would be an invalid range name.
If that doesn't fix it, can you share the file?