![]() |
|
#1
|
|||
|
|||
![]() Is it like shown in 2015!Q26? |
#2
|
|||
|
|||
![]()
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> |
#3
|
|||
|
|||
![]()
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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
wmedjaxnjr | Excel | 1 | 04-09-2016 04:22 PM |
![]() |
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 |