Use date to put a cost into a cell.

		Microsoft Office Forums > Microsoft Excel > Excel
Use date to put a cost into a cell.

FAQ

Thread Tools

Display Modes

06-29-2016, 10:51 AM

melvin1942 melvin1942 is offline

Windows 10 Use date to put a cost into a cell.

Office 2007

Advanced Beginner

Join Date: Apr 2016

Posts: 42

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>

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:44 AM.