ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help With Formula (https://www.excelbanter.com/excel-worksheet-functions/6178-help-formula.html)

mak November 11th 04 02:40 AM

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



JulieD November 11th 04 02:43 AM

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






All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com