cwbasset
New Member
- Joined
- Sep 28, 2003
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
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?
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?