LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Hodge
 
Posts: n/a
Default SUMIF problem


I am trying to create a SUMIF formula (maybe nested) that will take the
correct sum from a table of data that looks a little like below;

Initials Week created No of entries

AB 45 100
GH 46 80

I am trying to use this data to return a result into a summary table as
below

Week
45 46
Initials

AB
GH

for the person to the left & for the week specified above sum the
entries found in the data.

Hope someone can help.


--
Hodge
------------------------------------------------------------------------
Hodge's Profile: http://www.excelforum.com/member.php...o&userid=16342
View this thread: http://www.excelforum.com/showthread...hreadid=277308

 
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
Row Autofit problem Excel 2003 Matthias Klaey Excel Discussion (Misc queries) 0 January 19th 05 05:33 PM
Problem with date base units for x axis Peter Carr Charts and Charting in Excel 1 December 15th 04 09:11 AM
Paper Tray selection Problem, Michael Hoffmann Excel Discussion (Misc queries) 4 December 3rd 04 09:08 PM
label problem Raven Maniac Excel Worksheet Functions 5 November 10th 04 10:10 PM
Problem with Pivot Table Drop-Down Menus Mac Excel Worksheet Functions 4 November 7th 04 01:18 PM


All times are GMT +1. The time now is 07:15 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"