Thread: VBA code to sum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] santhosh14@gmail.com is offline
external usenet poster
 
Posts: 2
Default VBA code to sum

Hi all

i have column B which has around 600 values when my no.of.cycles (n) =
1,
then it will be B & C for n = 2, where n is specified by the user.

according to n i want to calculate this formula for the whole column,

=Round(SUM(Tabelle2!B3:B12)/counta(Tabelle2!B3:B12)-SUM(Tabelle2!B2:B11)/counta(Tabelle2!B2:B11);2)

so when n= 1 i want to take column B, and for n = 2 column B & C and so
on.
could anyone help me in programming this

advance thanks for ur help
santhosh.