Is a 3D SUMIF formula possible

  • Thread starter Thread starter Judy
  • Start date Start date
J

Judy

Hello all,

Can anyone tell me if there's a formula/function I can
use that works like a sumif but can be used across
multiple worksheets? I quess it would need to be a 3-D
SumIF.

Simple Example: I have 25 tabs in a workbook. The first
tab is a master which lists 50 account numbers in column
B. The other 24 tabs have the same column layout only
they do not have all the account numbers (the number of
lines varies).

On my master tab I want to sum all the values in column C
from each of the other 24 tabs IF the account numbers
(column B on all 25 tabs) match.

on tab 1 i've tried the followwing formula with no luck.
=SUMIF(tab2:tab25!B:B,tab1!B9,tab2:tab25!C:C)

Any ideas?
Judy
 
=SUMPRODUCT(SUMIF(INDIRECT("tab"&ROW(INDIRECT("2:25"))&"!
B1:B1000"),tab1!B9,INDIRECT("tab"&ROW(INDIRECT("2:25"))&"!
C1:C1000")))

HTH
Jason
Atlanta, GA
 
Back
Top