SUMIF formula over multiple worksheets not working like it should

[cwbasset]

Okay, I've really done it this time.

The sumif formula that I believe "should" be working for me is returning a #REF! error.

I need to pull data from 18 other tabs. I created a named range for those tab names and used this formula:

=SUMPRODUCT(SUMIF(INDIRECT("'"&All_Tabs&"'!$B$55:$B$110"),$B57,INDIRECT("'"&All_Tabs&"'!$d$55:$d$110")))

What am I missing?

 

[jasonb75]

Maybe there are one or more wrong names on the list. To check, in an empty column, try

Why do we always leave the simplest tests until last

 

[Marcelo Branco]

Why do we always leave the simplest tests until last

True, this should be the first thing to check...

M.

 

[cwbasset]

Aha!

Thank you SO MUCH! There was one tab that must of had an extra space in it. Once it was located and renamed, everything worked just fine!!!

 

[Marcelo Branco]

Thank you SO MUCH! There was one tab that must of had an extra space in it. Once it was located and renamed, everything worked just fine!!!

Wow we got it!

M.