#1
|
|||
|
|||
Use date to put a cost into a cell.
I want a formula to use a date see column I in the attached to put a cost column J into columns S, U, W and so forth.
I had this but for some reason I lost it. I know it started with =Product but that is all I can remember. I tried to send this earlier so their may be two of this. use this one. I thank you for your time. melvin1942 |
#2
|
|||
|
|||
Is it like shown in 2015!Q26?
|
#3
|
|||
|
|||
melvin1942
There you go melvin1942!
|
#4
|
|||
|
|||
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> |
#5
|
|||
|
|||
Thanks for send this back, but I cannot open it with excel. it does not show as an Excel program it only show as file. I had this happen one other time and had to have it sent to my email address. If you could do that it would be helpful.
melvin1942 |
#6
|
|||
|
|||
Well, and I don't understand what you are saying.
In the file I uploaded I put a formula in 2015!Q26 with result 191.94. You had made some calculation in 2015!Q25 returning a result of 203.94. If my formula does not return what you want it would be helpful if you told what the result should be. |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
If you would send this file by email so I can open it. I have down loaded it three times and tries to open it. It does not show as a Excel file so it will not let me open it. My email address is.
leroy9804@aol.com Thank you. melvin1942 |
#9
|
|||
|
|||
I am in doubt if you are interested in a solution from me, but if you are you might want to take a look at the attached.
You wrote: 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 As far as I can see the dates you mention are in column I, not in column J and they are not from 2016 but from 2015 while the date in AA6 is in year 2016. I don't know if you just want to check for month and not for year. I have (in the formula in AA7) assumed you want to check for both year and month and accordingly I have temporarily changed the year in AA6 to 2015. |
#10
|
|||
|
|||
Use Date to put cost into a cell
I would like to thank everyone that gave me info. on the topic. It was most helpful.
Mlevin1942 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |