Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

VBA code to sum

  Asked By: Hondo    Date: Aug 29    Category: MS Office    Views: 1648
  

In sheet1 column B to J which has 600 values each is wht i get if user
specifies n= 10, and according to that i want to calculate in sheet2

=Round(SUM(Tabelle1!B3:B12)/counta(Tabelle1!B3:B12)-SUM(Tabelle1!B2:B11)/co
unta(Tabelle1!B2:B11);2) copied down the column.

and then column K the average of B thru J.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Damon Perez     Answered On: Aug 29


Please rethink your problem and then describe it accurately. At the moment, you
seem to have a perfectly good formula and you want to average some columns.
Neither of these needs VBA.

What exactly are you looking for?

 
Didn't find what you were looking for? Find more on VBA code to sum Or get search suggestion and latest updates.




Tagged: