Hi,
Strange that you see the name error because that usually appears when a
function is spelt incorrectly - which does not seem to be the case. If you
wish to sum the amount that falls between two dates, you may use the
following
=SUMIF(Comm_Due_Date,"=04/01/2010",Comm_Balance)-SUMIF(Comm_Due_Date,"04/30/2010",Comm_Balance)
or
=sumproduct((Comm_Due_Date=04/01/2010)*(Comm_Due_Date=04/30/2010)*(Comm_Balance))
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"KDenise" wrote in message
...
Hi,
I need some assistance with tracking my commissions that are due to be
paid
each month. The "Comm Due Date" is in column "C", rows 3 - 30 which list
by
date all of the Commissions Due to be paid and the "Comm Balance" is in
column "H", rows 3 - 30 which has the Commission Balance due for each
sale.
I tried utilizing a formula from a post that I found from April '05 but
for
some reason I keep receiving a #NAME? error. I'm not sure what I am doing
wrong. I want to find the total due by month so that as I add additional
sales to the spreadsheet it will update the total due for each month. Can
anyone please help me?
=SUMIF(Comm_Due_Date,"=04/01/2010",Comm_Balance)+SUMIF(Comm_Due_Date,"=04/30/2010",Comm_Balance)
If you need additional information, please let me know.
KDenise