PC Review


Reply
Thread Tools Rate Thread

Sumif to multiple tabs

 
 
New Member
Join Date: Aug 2012
Posts: 2
 
      13th Aug 2012
Hi

I have a multiple tabs in a worksheet where I have similar condition just with a different first 8 digit data and numbers.

Previously this was what I did, link sumif formula to each of these tabs to derive to numbers. Is there a way to link 1 formula to all of these tabs in more time efficient way?

Tab 1 : 60111110xxxxxxxxx
Tab 2 : 60111111xxxxxxxxx

Not sure whether my question above can be understood Please help. Tks
 
Reply With Quote
 
 
 
 
New Member
Join Date: Aug 2012
Posts: 2
 
      13th Aug 2012
I guess I better use an example :

Worksheet A named Sheet 1, have few lines
Cell A1 : 6011121 Cell B1 : $2
Cell A2 : 6011122 Cell B2 : $1
Cell A3 : 6011123 Cell B3 : $4

Worksheet B named Sheet 2, have few lines
Cell A1 : 6015121 Cell B1 : $5
Cell A2 : 6015122 Cell B2 : $1
Cell A3 : 6015123 Cell B3 : $3

Now, I have a summary worksheet where I have this :
6011121 $xx
6011122 $xx
6011123 $xx
6015121 $xx
6015122 $xx
6015123 $xx

Is there a way to link the formula to multiple worksheets in one go instead link the sumif to each worksheet?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMIF formula that crosses multiple sheet tabs =?Utf-8?B?SkRheXdhbHQ=?= Microsoft Excel Misc 1 14th Jun 2007 06:25 PM
Sumif for multiple tabs =?Utf-8?B?QnJhZA==?= Microsoft Excel Worksheet Functions 2 17th Nov 2006 07:11 PM
How to get IE7 tabs be usable when multiple tabs are open Aluxe Windows XP Internet Explorer 2 24th Oct 2006 12:18 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Microsoft Excel Worksheet Functions 2 12th Jan 2005 12:01 AM
Using Sumif on multiple tabs Peg Microsoft Excel Worksheet Functions 1 30th Jul 2004 08:45 PM


Features
 

Advertising
 

Newsgroups
 


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