asingh
08-05-2006, 05:45 PM
Hi,
I have numbers in columns a,b,c. And in column d, I am summing [adding] the column contents. So cell d1 reads:
=SUM(A1:C1).
What I want is...suppose if I HIDE column 'b' then my sum should only be from the values in columns A and C. Can this be done using some standard Excel formulea.
I dont want to do it using macros.....! [Have all ready done that...!, now want to know if it is possible using standarnd spreadsheet functions..?]
regards,
Anil Singh
I have numbers in columns a,b,c. And in column d, I am summing [adding] the column contents. So cell d1 reads:
=SUM(A1:C1).
What I want is...suppose if I HIDE column 'b' then my sum should only be from the values in columns A and C. Can this be done using some standard Excel formulea.
I dont want to do it using macros.....! [Have all ready done that...!, now want to know if it is possible using standarnd spreadsheet functions..?]
regards,
Anil Singh