krisbuddies
New Member
- Joined
- Jul 30, 2018
- Messages
- 14
Morning all
Some help needed please - seems pretty simple but it's beyond my Excel knowledge!!
Data, as follows
<tbody>
</tbody>
A1:D7 are static tables, A9 and C9 are variables.
What I want my formula to do is look at A9 & C9, then add the 2 figures in B1:B7 & D1:D7 together.
So, in this example, the result would be 3.3 + 3 (because I need the formula to see if C9 is equal to or less than the figures in D1:D7.
Does that make sense?? I think this will be some sort of Index Match query, but I'm really struggling to get it to work! Thanks in advance...
Some help needed please - seems pretty simple but it's beyond my Excel knowledge!!
Data, as follows
A | B | C | D | E | |
1 | 12 | 3.1 | 2 | 2 | |
2 | 24 | 3.2 | 2.5 | 2.5 | |
3 | 36 | 3.3 | 3 | 2.75 | |
4 | 48 | 3.4 | 3.75 | 3 | |
5 | 60 | 3.5 | 4 | 3.25 | |
6 | 72 | 3.6 | 4.5 | 3.5 | |
7 | 84 | 3.7 | 5 | 3.75 | |
8 | |||||
9 | 36 | 3.5 |
<tbody>
</tbody>
A1:D7 are static tables, A9 and C9 are variables.
What I want my formula to do is look at A9 & C9, then add the 2 figures in B1:B7 & D1:D7 together.
So, in this example, the result would be 3.3 + 3 (because I need the formula to see if C9 is equal to or less than the figures in D1:D7.
Does that make sense?? I think this will be some sort of Index Match query, but I'm really struggling to get it to work! Thanks in advance...