@Sum Conditional Values within a Macro

  • Thread starter Jocko_MacDuff116
  • Start date
J

Jocko_MacDuff116

I created a Macro which

I am trying to create a macro which repeats the following steps

macro inputs value in C3 (values 1 thru 24)
each value entered changes the value in cell C5
enter the value in C5 in Col D rows 1 thru 24

MY MACRO INCLUDES

Step 1
GOTO cell D1
Highlight cells D1 to D24 and delete values (delete any old
values) in Col D)

Step 2
GOTO cell C3
enter value 1 (an integer)
GOTO cell D1 @if(C3=1, C5, D1) (a formula)

Step 3
GOTO cell C3
enter value 2 (an interger)

goto cell D2 @if(C3=2, C5, D2), (a formula)

repeat the above step for all values from 3 to 24
place resulting value from C5 in cells D3 to D24
UP TO HERE THE MACRO WORKS

then
GOTO cell D25
enter formula @sum(D1.D24)
THIS PART DOESNT WORK IT SHOWS THE TOTAL AS 0.00

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top