: What I understood you were trying to do was to produce in cell A1
the sum of the cells from row 3
in column B
to some calcuated row
in column B
. That is, the variable currrow
is calculated in your VBA script.
: I suspect that this is not
what you are trying to do. Can you explain what you want to achieve in a little more detail?
: Roger J Coult
: Grimsby, UK
THIS PROGRAM IS KIND OF AN AMATURE WAY OF FORECASTING SALES. AS EACH DAY PROGRESSES THE GROSS SALES ARE SUBMITTED AND ENTERED INTO A CELL (VIA A TEXT BOX) THAT BOX WILL BE MULTIPLIED BY THE FRACTION OF THE TOTAL NUMBER OF DAYS IN THE PERIOD. FOR INSTANCE ON THE FIRST DAY THE PERIOD IS 1/20 (GIVEN 20 SALES DAYS) THE NEXT DAY IS 2/20, AND THE NEXT 3/20 AND SO FORTH. THEREFORE; ON THE DAY BEFORE THE FINAL DAY YOU WILL HAVE 19/20. WHAT I NEED TO DO IS TO BE ABLE TO TAKE THE AVERAGE OF THE COLUMN OF SALES LETS SAY THE B COLUMN (WHICH IS INCREASED BY ONE EACH DAY) MULTIPLY THAT BY THE FRACTION TO SOMEHOW BE ABLE TO PREDICT GIVEN LINEAR SALES THE END OF THE MONTH TOTALS.
SO WHAT I NEED IS THE ABILITY TO TAKE A AVERAGE OF A COLUMN GIVEN THAT THE COLUMN ROW IS A VARIABLE.
I KNOW THAT THIS IS CONVOLUTED REASONING AND IT MAY BE FAULTY BUT ONCE THE PROGRAMMING IS WORKED OUT WE CAN WORK ON THE PREDICTION FORMULA.
I KNOW THAT THE BOSS WILL USE THIS PROGRAM TO SHOW ME THAT MY SALES ARE POOR AND THEREFORE I DON'T DESERVE A RAISE.
THANKS FOR YOUR HELP