LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Adding numbers in multiple rows

I have a 2003 spreadsheet that lists these column headers

LastName Firstname Grade NumberOfTardies

Each student has a row for each quarter, regardless of the number of
tardies the student received. So, Billy Thompson's would look like
this:

LastName Firstname Grade NumberOfTardies
Thompson Billy 8 0
Thompson Billy 8 1
Thompson Billy 8 8
Thompson Billy 8 7

What I want to do is have it total up the number of tardies per kid
per year, so in my example it would take all those totals and
ultimately look like this:

LastName Firstname Grade NumberOfTardies
Thompson Billy 8 16

Anyone know an easy way of doing that?

 
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
Adding rows to multiple worksheets at once Karina Excel Worksheet Functions 1 December 20th 07 01:28 PM
Adding data from multiple rows PCStechnical Excel Discussion (Misc queries) 2 October 11th 06 04:45 PM
Adding data from multiple rows PCStechnical Excel Worksheet Functions 2 October 11th 06 04:39 PM
Adding numbers in rows results in zero. help! Mr_Philby_Takeshi Excel Worksheet Functions 4 July 8th 06 04:27 PM
Re What is the formula for adding multiple numbers in a cell merlin_au Excel Discussion (Misc queries) 2 January 4th 05 11:50 AM


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

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

About Us

"It's about Microsoft Excel"