Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
How to make a button VBA code reference other VBA code subroutines??? | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
option buttons run Click code when value is changed via VBA code | Excel Programming |