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?