I am hoping to sum all b2 cells in multiple worksheets, but only if the worksheet contains the text "*404*"
so far i have =sum(feb_404:Totals!,b2)
That sums all the b2's on not just the worksheets that contain the text 404 in them. any ideas on how to fix?
On a new sheet, you will need to create a list of the sheets you are summing from. (say in range A1:A4)
Then use this formula: =SUMPRODUCT(SUMIF(INDIRECT("'"&A1:A4&"'!B1"),"*404*",INDIRECT("'"&A1:A4&"'!B2")))
It should give you the result you want. It assumes you have the *404* text in B1!
I hope this helps, please let me know!
Regards,
David
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".
Last edited by David A Coop; 02-22-2016 at 10:16 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks