Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-14-2023, 01:17 PM
VKiprijan VKiprijan is offline Goal Seek or What if Analysis to be used in order not to calculate the total revenue beyond certain Windows 10 Goal Seek or What if Analysis to be used in order not to calculate the total revenue beyond certain Office 2016
Novice
Goal Seek or What if Analysis to be used in order not to calculate the total revenue beyond certain
 
Join Date: May 2023
Posts: 4
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, 3 views)
Reply With Quote
  #2  
Old 09-16-2023, 04:35 AM
Alansidman's Avatar
Alansidman Alansidman is offline Goal Seek or What if Analysis to be used in order not to calculate the total revenue beyond certain Windows 11 Goal Seek or What if Analysis to be used in order not to calculate the total revenue beyond certain Office 2021
Mountain Maven
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 64
Alansidman is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 09-16-2023, 01:19 PM
joeu2004 joeu2004 is offline Goal Seek or What if Analysis to be used in order not to calculate the total revenue beyond certain Windows 7 32bit Goal Seek or What if Analysis to be used in order not to calculate the total revenue beyond certain Office 2007
Advanced Beginner
 
Join Date: Aug 2016
Posts: 30
joeu2004 is on a distinguished road
Default

deleted by me

Last edited by joeu2004; 09-16-2023 at 05:16 PM. Reason: deleted
Reply With Quote
  #4  
Old 09-18-2023, 06:34 AM
kilroyscarnival kilroyscarnival is offline Goal Seek or What if Analysis to be used in order not to calculate the total revenue beyond certain Windows 10 Goal Seek or What if Analysis to be used in order not to calculate the total revenue beyond certain Office 2021
Expert
 
Join Date: May 2019
Posts: 301
kilroyscarnival is a jewel in the roughkilroyscarnival is a jewel in the roughkilroyscarnival is a jewel in the rough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine multiple tables into one pivot table in order to do trend analysis marelisev Excel 2 04-15-2017 08:30 AM
viewing completed goal seek formula katomich Excel 8 03-05-2017 07:14 PM
Goal Seek or What if Analysis to be used in order not to calculate the total revenue beyond certain VBA with goal seek takes too long Stata15 Excel Programming 3 07-22-2015 12:22 AM
Automatic goal seek program-Help required calltobala Excel Programming 0 05-08-2015 08:41 AM
Excel VBA Multiple Automatic Goal Seek Required Please Assist us 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.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft