LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Syahira
 
Posts: n/a
Default sum up total baed on names

Let ay I have this table:

Math Paper A
Name Marks Total ( Paper A + Paper B)
Bob 92
Debbie 72
Carlos 63

Math Paper B
Name Marks
Carlos 87
Bob 56
Debbie 50

How do I total the marks let say for Bob? I know I just can add up the
column but I want to add up by name. Thank you
 
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
Subtotals in a Pivot Table MarkM Excel Discussion (Misc queries) 0 December 20th 05 04:01 PM
The filter didn't show all (2,254) names when I set it up Darrell Excel Discussion (Misc queries) 2 December 17th 05 04:25 PM
Copying a total from another Sheet bcemail Excel Worksheet Functions 4 November 22nd 05 07:00 PM
matching the column b(sku)c(count)with A sammc2 Excel Worksheet Functions 0 November 3rd 05 07:42 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM


All times are GMT +1. The time now is 11:25 AM.

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"