LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default Excel 2003 Multi Worksheet Sumproduct?

I just cannot solve this one. Any help you can give is much appreciated......

There are 12 sheets labled Jan, Feb Mar etc. Each sheet has the following

Col A - Name
Col C - Data to be summed

On a summary sheet I would like to able to do the following : -

For a particular month, say May, and a particular Name, sum all of the Col C
data
for the preceeding months (in this case from worksheets Jan to April).

Thanks in advance

Kevin

 
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
Multi Worksheet Sumproduct Excel 2003 wild turkey no9 Excel Discussion (Misc queries) 4 May 17th 08 03:51 PM
a multi-rounded sumproduct driller2 Excel Worksheet Functions 3 December 16th 06 03:16 PM
SUMPRODUCT + multi conditions BernzG Excel Worksheet Functions 3 May 10th 06 02:23 AM
Excel 2003 Multi-worksheet copy via drag/drop idrabefi Excel Worksheet Functions 0 April 12th 05 06:18 PM
Multi-selection problem in Excel XP and 2003 Vicente Zambrano Excel Discussion (Misc queries) 0 February 10th 05 11:29 PM


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