Assume that column A (rows 2-7)has dates in it and Column
B (rows 2-6)has $ amounts. I want to sum the amounts in
Column B for those rwos where the month in column A is
March. The formula "=SUMIF(MONTH(A2:A7),3,B2:B7)" doesn't
work. Can anyone help?