Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 11th 04, 02:40 AM
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



  #2   Report Post  
Old November 11th 04, 02:43 AM
JulieD
 
Posts: n/a
Default

Hi

you can use a SUMIF function for this
=SUMIF(A11,2004,A22)

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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
revert formula insertion to old method Don't be a pain in the ass Setting up and Configuration of Excel 0 January 24th 05 02:49 PM
Simple formula doesn't quite add up circeo Excel Discussion (Misc queries) 3 January 17th 05 10:04 PM
Formula displays does not calculate Neil Bhandar Excel Discussion (Misc queries) 4 January 10th 05 11:55 PM
how do I make a formula NOT change when the data range is moved? Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 10:02 PM
Excel 2003 - Formula result shows as 0:00 Serena Excel Worksheet Functions 4 November 11th 04 11:18 PM


All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017