Thread: Goal Seek or What if Analysis to be used in order not to calculate the total revenue beyond certain
View Single Post
 
Old 09-14-2023, 01:17 PM
VKiprijan VKiprijan is offline Windows 10 Office 2016
Novice
  
Join Date: May 2023
Posts: 15
VKiprijan is on a distinguished road
Default Goal Seek or What if Analysis to be used in order not to calculate the total revenue beyond certain
Hi Everyone,

I need a two-way solution either in Goal Seek or in What if Analysis that WILL NOT calculate the total sum of revenue in the cell E15 if the dates in the cell B2 and B3 are between 01-Sep-2023 and 31-Dec-2023 for example. Also, if you can provide the formula in cell E15 that will do this will be great.

Thank you in advance.
Attached Files
File Type: xlsx Book1.xlsx (9.4 KB, 5 views)
Reply With Quote