Hi,
I've been looking on this for a while and can't seem to figure it out. I've fried looking for a solution on the internet, but it won't help.
So, in column E I want to sum up all amounts in C until a blank cell is reached. So for cell E3 I want to sum up 195,97 and for cell E8 I want to sum up 272,96 until 136,48.
<colgroup><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
What's the formula for this?
It seems like =IF(E3="";SUMIF(D:D;D3;E:E);"") won't do the trick.
I've been looking on this for a while and can't seem to figure it out. I've fried looking for a solution on the internet, but it won't help.
So, in column E I want to sum up all amounts in C until a blank cell is reached. So for cell E3 I want to sum up 195,97 and for cell E8 I want to sum up 272,96 until 136,48.
A | B | C | D | E | |
1 | Benefit | Emp.no | Bought | Budget | Total bought |
2 | Buy additional leave | 156 | 570,78 | ||
3 | 195,97 | 0 | |||
4 | Bicycles | 8499 | 464,50 | ||
5 | Buy additional leave | 85277 | 439,21 | ||
6 | Buy additional leave | 95 | 84,37 | ||
7 | Buy additional leave | 82222 | 704,30 | ||
8 | Buy additional leave | 98322 | 265,53 | ||
9 | 272,96 | 0 | |||
10 | 226,38 | 0 | |||
11 | 136,48 | 0 | |||
12 | Planning my pension | 98226 | 136,48 | ||
13 | Buy additional leave | 89577 | 428,03 | ||
14 | Buy additional leave | 89468 | 216,18 | ||
15 | Buy additional leave | 89668 | 705,07 | ||
16 | Planning my pension | 87519 | 320,00 | ||
17 | Fitshop | 85532 | 150,00 | ||
18 | Planning my pension | 87958 | 405,40 |
<colgroup><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
What's the formula for this?
It seems like =IF(E3="";SUMIF(D:D;D3;E:E);"") won't do the trick.