Hi,

Hopefully a very easy query somebody can help me with.

I have a spreadsheet whereby the sale of an item is listed in row order, one column lists the sale price and in another column I have a sale date.

What formula can I use which will scan each column and add the total values of sales conducted in a specific year (not interested in value of specific items, just yearly totals of sales).

Thanks in advance for any help.

Regards Paul