Time spreading for tasks using macros

[Derekc25]

Hi,

I'm trying to create macros for an excel sheet, where i have different actions required for different tasks, each action has its own individual time, I place a "X" in the cell underneath each action and sum up all cells containing an "X" at the end.
So that when I place an X in say 4 cells and each cell will be related to a time in seconds or minutes, how can I add these 4 values and display the total time these actions would require?
The tasks are going down in column and the actions are going across the rows.

As I have not had a lot of experience with VB can anyone suggest a possible method for this,
I tried using simple IF statements eg, =if(B4=="X",AA4,) where i was placing the time in cell AA4, but as I have well over 100 tasks this could get v. messy!
and I dont know how to link a cell to a time value where the X is placed.


Any help would be appreciated.
Derek

[Killer42]

My Excel VBA syntax is a bit rusty. But in concept, you should be able to use a loop to go down the column with the Xs, and for each one you hit, use the Offset() function to pick up the corresponding time value.