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
|