View Single Post
 
Old 04-23-2016, 03:49 PM
melvin1942 melvin1942 is offline Windows 10 Office 2007
Advanced Beginner
 
Join Date: Apr 2016
Posts: 42
melvin1942 is on a distinguished road
Default Formula to use a date to calculate an amount $.

What I am trying to do is to put a date like 1/1/2016 say in column A1 and another date 01/15/2016 in A3 then put an amount $300.00 in C1 and $200.00 in C3 . Then have the formula look at the dates in A1 and A3 and sum up the amount in C1 and C3. In other words it would look at the entire A column for any date that has 1/2016 in it and then find the amounts in column C that goes with that month.

I hope you under stand what I mean I am not very good at explaining what I want.

Thank you for your time.

melvin1942

Last edited by melvin1942; 04-23-2016 at 03:52 PM. Reason: had a wrong word
Reply With Quote