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,101
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

Thread Tools
Display Modes


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:05 AM.


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