well, if you want to use SUMIF to get the sum of col B for dates in col A in
Apr 2010, this seems to work fine:
=SUMIF(A:A,"="&--"1 Apr 2010",B:B)-SUMIF(A:A,"="&--"1 May 2010",B:B)
Care should be taken to be unambiguous when dealing with dates
--
Max
Singapore
---
"KDenise" wrote:
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