Your formula fails, Ashish, because 10/1/2008 to Excel is 10 divided by 1
divided by 2008. You need to use either Date(2008,10,1) or --"10/2/2008"
Regards,
Fred.
"Ashish Mathur" wrote in message
...
Hi,
You can use the SUMPRODUCT() formula he
=sumproduct((A1:A310/1/2008)*(A1:A3<10/31/2008),B1:B3). For other
months, change the month in the date.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Stilmovin" wrote in message
...
I am trying to figure out how to sum a function if it apears between a
set
given dates. my sheet looks something like this.
YTD Bid Summary
A B
1 10/12/08 25,000
2 10/28/08 75,000
3 11/25/08 50,000
4 Total 150,000
YTD Monthly Bid Summary
A B
1 October Total of all October
2 November Total of all November
3 December Total of all December
4 Total
I do not have my columns or rows named I tried using the following
equation
=SUMIF('YTD Bid Summary'!E6:E34,"=10/31/08",'YTD Bid
Summary'!J6:L34)+SUMIF('YTD Bid Summary'!E,"10/01/08",'YTD Bid
Summary'!J6:L38)
It just says #NAME?