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
|