I have a date column and a cost column and I would like to get a monthly total of cost.
Here is an example of how my worksheet is set up:
Our_Cost Completion_Date
$3000 7/14/2004
$0 9/27/2005
$1288 10/25/2004
I would like to use a formula to give me the total cost of a single month. I tried a SumProduct formula but it gave me the #Value!
Any Ideas as to how this can be done. I know this has to be simple, I'm just stumped.
Thanks
Here is an example of how my worksheet is set up:
Our_Cost Completion_Date
$3000 7/14/2004
$0 9/27/2005
$1288 10/25/2004
I would like to use a formula to give me the total cost of a single month. I tried a SumProduct formula but it gave me the #Value!
Any Ideas as to how this can be done. I know this has to be simple, I'm just stumped.
Thanks