Hi,

I have to sumup the numbers apprearing in various columns against column
headers in a range. say for example I have columns A to D and rows 1 to 4. so
I have four column headers against which there can be values in any of the
columns B,C and D.

I am using the below formula in cell E1 but the result in always ZERO.

=sumif(A1:D4,A1,A1:D4)

I wonder it must be very easy but not able to krack it. Kindly help.

Thanks
MA