Summing three columns of different dimensions on aSummary Sheet

[siddharth]

Hello,

I want to sum up three columns of different height on a summary sheet ( Sheet 4 ).I'm getting "#NAME" when I use =SUM(Reduction_KSI_Prior,Reduction_KSI_2002,Reduction_KSI_2003)
where ;Reduction_KSI_Prior,Reduction_KSI_2002,Reduction_KSI_2003 are the names of three columns without header on Sheet1,Sheet2,Sheet3 respectively.

Kindly Help.

Regards,
sid.

 

[hiker95]

siddharth,

This works for me:
=SUM(Reduction_KSI_Prior)+SUM(Reduction_KSI_2002)+SUM(Reduction_KSI_2003)

 

[barry houdini]

In principle there's no reason why your initial formula won't work. #NAME? error would indicate that at least one of your named ranges hasn't been recognised.

Check that you have spelt the names correctly in the formula compared with the definitions......