View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ricky from Pine Island Ricky from Pine Island is offline
external usenet poster
 
Posts: 1
Default I want to use sumif to sum up a column based on a range of dates

I would like to sum up a column of agent commissions using a range of dates.
For example: the agent has input all of his commissions for january 1, 2006
through april 30, 2007. I would like a sumif formula that sums up the
commissions for just the year 2006. Is this possible with sumif? I have
tried using = and <= but it doesn't work.

Thank you, Ricky