Name Manager Not Working

Thanks but still it's only counting Sheet1 only.

Originally Posted by benishiryo

hi there. what you're trying to do is 3D referencing. and it doesn't work like that for COUNTIFS or SUMIFS. you would have to use INDIRECT. so change all your Named Range formulas like this:
=INDIRECT("'"&{"Sheet1";"Sheet2"}&"'!A:A")

the other 2 would be changing the red portion to B:B & C:C

Edit: then surround the formula with a SUM:
=SUM(COUNTIFS(A_Series,B2, B_Series,B3, C_Series,B4))