I've used subtotal a lot and never has it failed me. However, now I am lost. Here's my data-set (simplified for example):
<tbody>
</tbody>
The formula I use is the following (cell B2):
=IF($A2="Value";5*2000;SUBTOTAL(9;$B$1:B1))
It gives 10.000, like it should. Next, cell B3:
=IF($A2="Value";5*2000;SUBTOTAL(9;$B$1:B2))
Nice, now B4 should give me the total of the 2 rows above. However, it doesn't...
Now, if I put the value (10.000) as a hard copy, the formula works all of a sudden...
Anybody where who can help me out?
With Formula | Flat Data | |
Value | 10.000 | 10.000 |
Value | 10.000 | 10.000 |
Result | 20.000 | |
Value | 10.000 | 10.000 |
Value | 10.000 | 10.000 |
Value | 10.000 | 10.000 |
Result | 50.000 |
<tbody>
</tbody>
The formula I use is the following (cell B2):
=IF($A2="Value";5*2000;SUBTOTAL(9;$B$1:B1))
It gives 10.000, like it should. Next, cell B3:
=IF($A2="Value";5*2000;SUBTOTAL(9;$B$1:B2))
Nice, now B4 should give me the total of the 2 rows above. However, it doesn't...
Now, if I put the value (10.000) as a hard copy, the formula works all of a sudden...
Anybody where who can help me out?