Help With Formula
 

Hello, I am looking to calculate the total inspections per year from the
below example based on the year it occures, I would like to somehow look up
the date and only sum the inspections that occur within that year.

2004 2004 2005 2005 2006 2006
Inspections per Year 1 1 0 1 1 2

2004 2005 2006 Total Inspections
per year formula?

thanks in advance

Hi

you can use a SUMIF function for this
=SUMIF(A1:D1,2004,A2:D2)

Regards
JulieD

"mak" wrote in message
...
Hello, I am looking to calculate the total inspections per year from the
below example based on the year it occures, I would like to somehow look
up
the date and only sum the inspections that occur within that year.

2004 2004 2005 2005 2006 2006
Inspections per Year 1 1 0 1 1 2

2004 2005 2006 Total Inspections
per year formula?

thanks in advance