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

Attached Files

Northpoint 8N Restoratio Financial 2015 _ 2016.xlsx (36.9 KB, 13 views)

Is it like shown in 2015!Q26?

Attached Files

Northpoint_2.xlsx (37.1 KB, 13 views)

There you go melvin1942!

Attached Files

Northpoint 8N Restoratio Financial 2015 _ 2016_melvin1942.xlsx (37.0 KB, 17 views)

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>

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

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.

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

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

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.

Attached Files

Northpoint_3.xlsx (37.2 KB, 6 views)

I would like to thank everyone that gave me info. on the topic. It was most helpful.

Mlevin1942