Thread
:
How to indicate in formula to choose the entire column starting from a specified cell?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave Peterson
Posts: n/a
How to indicate in formula to choose the entire column starting froma specified cell?
=sum(C:C)
for the whole column.
=sum(c4:c65536)
for C4 and everything after that.
=sum(c2:c12)-sum(c5,c10)
is one way.
=sum(c2:c4,c6:c9,c11)
is another.
wrote:
How would you indicate in a formula for Excel to choose an entire
column? Say, for example I want to sum up all the values in column C
starting from C4?
Also, how would I indicate to Excel to sum up values excluding a few?
Say I want to sum up columns C2 to C12 but not C10 and C5.
Thank you!
--
Dave Peterson
Reply With Quote