Looking for a formula to calculate expenses within a certain month
Posted by Gina Hasselbring on August 14, 2001 9:15 AM
This is probably much easier than I am making it, but I am just learning Excel and can not figure this out.
I am doing an expense sheet to calculate recruiting costs. On one worksheet, I am keeping track of when we put our ads in the paper and how much they cost.
What I would like is a formula that will calculate how much we spent on ads in April. An example is:
(in column D) (in column E)
Only, I have all dates and costs listed in this worksheet(May, June, etc.) and would like for it to pull out only April's costs.
By this point, it would have been easier for me to use my calculator, but I'm determined to find this out now. Any help anyone can give would be greatly appreciated.