Adding Cell from certain worksheets.

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Is there a way to this?

=sumif("Worksheet with the last 2 digits of 04", A1)

I just want it to add the cell A1 from worksheets that
the name ends in 04. Thanks for your help.
 
Hi bob
would it be possible for you to create a list of all worksheets in a
cell range of you summray worksheet. e.g. in the cells X1:X10. If yes
try the following formula
=SUMPRODUCT((RIGHT(X1:X10,2)="04")*SUMIF(INDIRECT("'" & X1:X10 &
"'!A1"),"<>0"))
 
Back
Top