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

I want to use sumif to sum up a column based on a range of dates
 

=SUMPRODUCT(--(YEAR(A1:A100=2006),B1:B100)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ricky from Pine Island" <Ricky from Pine
wrote in message ...
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

I want to use sumif to sum up a column based on a range of dat
 

=SUMPRODUCT(--(YEAR(A1:A100)=2006),B1:B100)


"Bernard Liengme" wrote:

=SUMPRODUCT(--(YEAR(A1:A100=2006),B1:B100)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ricky from Pine Island" <Ricky from Pine
wrote in message ...
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