Please excuse what will be a question with the most simple answer, but I'm suffering with Brain Fog today.
From the following collection of cells:
<tbody>
</tbody>What I need to achieve in cell A11, is to multiply the values in range A2:A10 by the values in another column where the cell value in A1 is a match to a value in range B2:G2
I'm sure I've done this before and that it's not difficult, I'm just having a problem today getting my head around the logic.
The answer in this case should be the equivalent of adding the sums of (A4*D4), (A6*D6), (A8*D8) and (A10*D10) = 222.25
Many thanks. Hoping the fog will clear by morning.
From the following collection of cells:
A | B | C | D | E | F | G | |
1 | 0.75 | ||||||
2 | 0.25 | 0.50 | 0.75 | 1.00 | 2.00 | 3.00 | |
3 | 1.44 | 1.46 | 1.53 | 1.68 | 2.32 | 3.01 | |
4 | 50 | 1.78 | 1.80 | 1.88 | 1.92 | 2.40 | 3.22 |
5 | 0.48 | 0.60 | 0.70 | 0.80 | 0.90 | 1.00 | |
6 | 25 | 1.23 | 1.26 | 1.35 | 1.40 | 1.88 | 2.52 |
7 | 1.60 | 1.70 | 1.80 | 1.90 | 2.22 | 3.33 | |
8 | 10 | 0.97 | 1.02 | 1.30 | 1.55 | 1.75 | 1.99 |
9 | 1.41 | 1.43 | 1.66 | 1.84 | 1.98 | 2.04 | |
10 | 50 | 1.22 | 1.25 | 1.63 | 1.80 | 2.21 | 2.84 |
11 |
<tbody>
</tbody>
I'm sure I've done this before and that it's not difficult, I'm just having a problem today getting my head around the logic.
The answer in this case should be the equivalent of adding the sums of (A4*D4), (A6*D6), (A8*D8) and (A10*D10) = 222.25
Many thanks. Hoping the fog will clear by morning.