Thanks Arvi, does SaleDate have to be replaced by the month required or is
that the column title?

Many thanks
Simon

"Arvi Laanemets" wrote:

Hi

To return summary commissions for January of current year
=SUMPRODUCT(--(MONTH(SaleDate)=1,--(YEAR(SaleDate)=YEAR(TODAY()),Commission)

The same for last year
=SUMPRODUCT(--(MONTH(SaleDate)=1,--(YEAR(SaleDate)=YEAR(TODAY()-1),Commissio
n)

Arvi Laanemets


"Pieman" wrote in message
...
Does anyone know the best formula for adding figures in a column that
correspond to each month of the year?

I have a sales register with the date of sale and commission on each row
but
want to display the total commissions for each month of the current year
on
one worksheet and monthly totals for previous year on athother worksheet.

Any ideas would be greatly appreciated.

Thanks
Simon