Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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: 358
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
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



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 11:24 PM.


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