Name Manager Not Working

Hello Everyone!
I am having a problem, I defined few name in manager but that are not working. I Defined names with multiple sheets with same Column.
See the attachment.

Please resolve it and tell me where I'm making mistake.Demo.xlsx

To check/edit defined ranges, click Formulas ribbon > Name Manager
Think you need to change all 3 defined names (in turn) to be like this:
A_Series =Sheet1!$A:$A
Likewise for B_series, C_series
--------------------------------------------------
Any good? Wave it, click on the little star at the bottom left of my responses

But the issue is, I want name Manager to work for 2 or more sheets simultaneously, liek A_Series = Sheet1!$A:Sheet2!$A.
I know it will work with single sheet but I need to set multiple here.

You're absolutely right, it's working with CountA but why 'Countifs' and 'Sumifs' are not working with this Range?

Originally Posted by Ron Coderre

Those ranges seem to be working for me.
Try this on any sheet:
=COUNTA(B_Series)
=SUM(A_Series)

The first formula returns: 36
The second returns: 72,450

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))

Still waiting for someone to respond and resolve my issue..... I need it.

Here's how I'd do it.

Put a countifs formula on each sheet, then sum them..

in say E2 of sheet1 and sheet2 put
=COUNTIFS(A2:A19,Sheet3!B2,B2:B19,Sheet3!B3,Sheet1!C2:C19,Sheet3!B4)

Then on Sheet3 B5 put
=SUM(Sheet1:Sheet2!E2)

This is not, what I need. My sheet contains countifs and sumifs more than 100 times, just manual steps make me crazy.

Originally Posted by Jonmo1

Here's how I'd do it.

Put a countifs formula on each sheet, then sum them..

in say E2 of sheet1 and sheet2 put
=COUNTIFS(A2:A19,Sheet3!B2,B2:B19,Sheet3!B3,Sheet1!C2:C19,Sheet3!B4)

Then on Sheet3 B5 put
=SUM(Sheet1:Sheet2!E2)