Microsoft Office Forums Goal Seek or What if Analysis to be used in order not to calculate the total revenue beyond certain
 Register FAQ Search Today's Posts Mark Forums Read

#1
09-14-2023, 01:17 PM
 VKiprijan Windows 10 Office 2016 Novice Join Date: May 2023 Posts: 4
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.

Attached Files
 Book1.xlsx (9.4 KB, 3 views)
#2
09-16-2023, 04:35 AM
 Alansidman Windows 11 Office 2021 Mountain Maven Join Date: Apr 2019 Location: Steamboat Springs Posts: 64

Where are the dates referencing the values that appear in Column E. How about mocking up a solution so we understand exactly what you are looking for.
#3
09-16-2023, 01:19 PM
 joeu2004 Windows 7 32bit Office 2007 Advanced Beginner Join Date: Aug 2016 Posts: 30

deleted by me

Last edited by joeu2004; 09-16-2023 at 05:16 PM. Reason: deleted
#4
09-18-2023, 06:34 AM
 kilroyscarnival Windows 10 Office 2021 Expert Join Date: May 2019 Posts: 301

Yeah, I tried to suss out what you were asking for. I think your spreadsheet is all typed in values except for the sum at the bottom, yes?

You give the starting and ending dates, but no date to compare to those. Are you asking for it to not total if the variable TODAY is not between those dates? Or if a reference date typed elsewhere doesn't fall between those dates?

What occurred to me to be a more likely scenario is that you're looking to populate the table with only those expenses incurred between those dates, if you're pulling them from a larger table of expenses by date. But if so, we'll need to see more of your work.

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post marelisev Excel 2 04-15-2017 08:30 AM katomich Excel 8 03-05-2017 07:14 PM Stata15 Excel Programming 3 07-22-2015 12:22 AM calltobala Excel Programming 0 05-08-2015 08:41 AM champaben Excel Programming 13 06-22-2014 05:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:32 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top