Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-28-2016, 10:09 PM
xor xor is offline Use date to put a cost into a cell. Windows 10 Use date to put a cost into a cell. Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default


Is it like shown in 2015!Q26?
Attached Files
File Type: xlsx Northpoint_2.xlsx (37.1 KB, 15 views)
Reply With Quote
  #2  
Old 06-29-2016, 10:51 AM
melvin1942 melvin1942 is offline Use date to put a cost into a cell. Windows 10 Use date to put a cost into a cell. Office 2007
Advanced Beginner
Use date to put a cost into a cell.
 
Join Date: Apr 2016
Posts: 42
melvin1942 is on a distinguished road
Default

I sorry I do not understand what you are saying. All 2015 Q26 is a number I calculated by just putting in the cells. I had a formula that looked at the date in column I and cost in column J and put that in the right cell under the right month in cells S, U, W and so forth. And it total all the cost for that month.

I can give you parts of the formula.

=Product it had $I11:$I30 it also had $J11:$J30 it also had <Name Year Month>
Reply With Quote
  #3  
Old 06-29-2016, 01:34 PM
melvin1942 melvin1942 is offline Use date to put a cost into a cell. Windows 10 Use date to put a cost into a cell. Office 2007
Advanced Beginner
Use date to put a cost into a cell.
 
Join Date: Apr 2016
Posts: 42
melvin1942 is on a distinguished road
Default

If you look at the Attach in my first post and read the note in columns S thru AC in red. I want the totals of each month from column J go be put in the months. In other word the date of 11/18/2016 in column J would pick out the cost that goes with at date and would put the totals of that in AA7. Thank you for your time. the formula I had started with =PRODUCT and then it had in it NAME MONTH and YEAR and it also had like $I$11: $I$30 and $J$11$J$30 . That is all I can remeber about it. Thank you for your time.

Melvin1942
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Use date to put a cost into a cell. Need help with using traffic lights in one cell based on date value in a different cell wmedjaxnjr Excel 1 04-09-2016 04:22 PM
Use date to put a cost into a cell. Cost resource not taken in real cost pascalbidouille Project 1 08-21-2015 01:25 PM
calculate date if date entered in cell, do nothing if blank ConfuddledOne Excel 3 11-07-2014 09:37 AM
Make table cell active add date count date MelHerndon Word VBA 3 01-21-2013 04:23 PM
How can I make a cell color RED under the Today's date cell? Learner7 Excel 2 07-08-2010 12:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:00 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