Sum for name ranges at the same time

[geniusufo007]

HI EVERYONE

In the attachment I have assigned three names i.e JANUARY, FEBUARY, MARCH to three ranges as below
January =C6:C10
February =D6:D10
March =E6:E10

now I want to sum all these three at the same time by choosing the range i.e. C11:E11, is this possible if i want to sum all the name ranges at the same time

[Pete_UK]

Use this in C11:

=SUM(INDIRECT(C5))

then copy across.

Hope this helps.

Pete

[geniusufo007]

Thanks mr pete_uk for your solution and quick reply

[Pete_UK]

You're welcome - thanks for the rep.

Pete