L
laandmc
I have a problem where I want to times some cells together if certain
conditions are satisfied. Tables A has the conditions in, tables B and C have
the information I want to times together, and the bottom two tables have what
I want as an outcome, the left table showing the sums I want to do (note I do
not want to see this table in what I’m doing it is just for examples purposes)
If the table A has a yes in its cell I want the two respective cells in
tables B and C to be times together and added to any other respective cells
that are in the same row.
Any help would be appreciated.
A jan feb mar
a yes yes
b yes yes
B jan feb mar C jan feb mar
a 1 2 3 a 6 5 4
b 4 5 6 b 3 2 1
totals totals
a = 1*6 + 2*5 a 16
b = 5*2 + 6*1 b 16
conditions are satisfied. Tables A has the conditions in, tables B and C have
the information I want to times together, and the bottom two tables have what
I want as an outcome, the left table showing the sums I want to do (note I do
not want to see this table in what I’m doing it is just for examples purposes)
If the table A has a yes in its cell I want the two respective cells in
tables B and C to be times together and added to any other respective cells
that are in the same row.
Any help would be appreciated.
A jan feb mar
a yes yes
b yes yes
B jan feb mar C jan feb mar
a 1 2 3 a 6 5 4
b 4 5 6 b 3 2 1
totals totals
a = 1*6 + 2*5 a 16
b = 5*2 + 6*1 b 16