Sum is between two dates

D

Davidmj54

I have a spreadsheet that I use to calculate my sales. It is a good solution
for totaling what my sales for the year but I also want a monthly breakdown.
I need a formula that will return the total sales for January. In the
example below the answer would be $25,000.

Here is an examply of my list:
Candidate Company Start Date Fee
Jim Company A 1/1/2004 $18,000
Dan Company B 1/17/2004 $7,000
Sara Company A 5/24/2004 $9,600
Tina Company C 7/20/2004 $8,250
Carol Company D 9/2/2004 $7,500
Dave Company A 9/20/2004 $11,600

Thanks in advance for any assistance.

Dave
 
N

Nick Hodge

David

If the dates are in chronological order then you could use Excel's
'Subtotal' function. This is implemented easily via Data>Subtotal... and
using the dialog presented.

You may also want to look at pivot tables if there are many
hundreds/thousands of entries.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
B

Bob Phillips

Formula solution

=SUMPRODUCT(--(TEXT($C$1:$C$100,"mmm")="Jan"),$D$1:$D$100)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top