SumProduct over multiple sheets

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Hello
The below formula does one sheet. I have ten. Is there a way to have it sum
all ten for me that does not require a long formula

Thanks for your help

=SUMPRODUCT(('Line7'!$C$15:$C$114=C7)*('Line7'!$G$15:$G$114='Numbers'!$S$9)*('Line7'!$AF$15:$AF$114))
 
I'd use 10 different formulas. Then sum them in an eleventh formula.

In fact, if you put each of those formulas in a dedicated cell (say A1 of each
individual sheet), you could use a formula like:

=sum('line1:line10!a1)

As long as all the other sheets are between line1 and line10.
 
Back
Top