# 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

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?

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 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 OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?SkRheXdhbHQ=?= Microsoft Excel Misc 1 14th Jun 2007 06:25 PM =?Utf-8?B?QnJhZA==?= Microsoft Excel Worksheet Functions 2 17th Nov 2006 07:11 PM Aluxe Windows XP Internet Explorer 2 24th Oct 2006 12:18 AM Oscar Microsoft Excel Worksheet Functions 2 12th Jan 2005 12:01 AM Peg Microsoft Excel Worksheet Functions 1 30th Jul 2004 08:45 PM

Features