Add one cell based on a value of another

[PChad]

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

[mrice]

Have a look at SUMIF or SUMIFS.

[Speshul]

=sumif(range_with_date,year(range_with_date)=2014,range_with_values)

So it will look like

=SUMIF(A2:A500,YEAR(A2:A500)=2014,B2:B500)

This assumes there are 500 rows of data and the Dates are in Column A, and the Values to be added are in Column B