View Single Post
  #1   Report Post  
mak
 
Posts: n/a
Default 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