Try it like this using cells to hold the date boundaries...

A1 = lower date boundary = 4/1/2010
B1 = upper date boundary = 4/30/2010

=SUMIF(Comm_Due_Date,"="&A1,Comm_Balance)-SUMIF(Comm_Due_Date,""&B1,Comm_Balance)


--
Biff
Microsoft Excel MVP


"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