Hello everyone,
I'm trying to create an OFFSET with SUMIF but failing. Maybe you can help?
I'm trying to SUM all values that are below "54321"
<tbody>
</tbody>
This is stumping me -got any ideas?
RB
I'm trying to create an OFFSET with SUMIF but failing. Maybe you can help?
I'm trying to SUM all values that are below "54321"
A | B | C | D | E | F | G | H | I | |
1 | Look for the number listed in A2 throughout A3 to R300 and SUM the values below each instance. The result of this cell should be 82 (50 + 25 + 7 =82) Note that the values below 44444 were NOT summed. | ||||||||
2 | 54321 (this is the value to look for) | ||||||||
3 | 54321 | 44444 | 54321 | ||||||
4 | 50 | 1000 | 7 | ||||||
5 | 54321 | 44444 | 44444 | ||||||
6 | 25 | 1000 | 1000 | ||||||
7 | |||||||||
8 | |||||||||
9 |
<tbody>
</tbody>
This is stumping me -got any ideas?
RB
Last edited: