Sum upwards between blank cells

[Anthea]

Please could someone advise me how to do this ...
I am using an array formula which I found - however, I need it to sum upwards and not down

The formula is
=SUM(A1:INDEX(A1:A3000,MATCH(TRUE,(A1:A3000=""),0)))
I need the total 682.20 to be on the green line, the total 191.20 on the next green line and so on

Does anyone have an idea of how I might accomplish this - I have been fiddling with it for days and just cannot work it out
Thanking you for your time

 

[Sam_D_Ben]

Ok, the given formula finds the first empty cell in the given range and sum up the range above the empty cell. Kindly post some sample data.

 

[Anthea]

Am I able to up- load a worksheet to the page?
I am battling to get a screenshot uploaded too (so sorry not too tech-savvy) - I found MrExcelHTMLMaker20170807 but no instructions on how to use it

 

[Joe4]

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

Also, some people will upload files to a file sharing site, and provide a link here, but note that for security reasons, many people are not able (or willing) to download files off of the internet.

 

[Anthea]

Hello Joe4 ... is this the information you require?

Excel 2016 (Windows) 32 bit
	F	G
10		Total
11	,78.4,	,682.20,
12	,47.2,
13	,202.0,
14	,150.2,
15	,75.5,
16	,97.9,
17	,19.9,
18	,1.9,
19	,9.2,
20
21	,9.1,	,161.20,
22	,0.8,
23	,1.9,
24	,149.4,
25
26	,154.9,	,320.30,
27	,149.2,
28	,16.2,
29
Formatted Logbook safe2

Cell Formulas
Range	Formula
G11	{=SUM(F11:INDEX(F11:F3000,MATCH(TRUE,(F11:F3000=""),0)))}
G21	{=SUM(F21:INDEX(F21:F3010,MATCH(TRUE,(F21:F3010=""),0)))}
G26	{=SUM(F26:INDEX(F26:F3015,MATCH(TRUE,(F26:F3015=""),0)))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Joe4]

Hello Joe4 ... is this the information you require?

I wasn't the one who asked you for the data.
I was just acting as Moderator and telling you how you can do it (in response to your previous post asking how to do it).

 

[Eric W]

Is this what you want?

Excel 2012

	F	G
Total

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]10[/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]78.4[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]47.2[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]202[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]150.2[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]75.5[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]97.9[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]19.9[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]1.9[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]9.2[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"]682.2[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]9.1[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]0.8[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]1.9[/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]149.4[/TD]

[TD="align: center"]25[/TD]
[TD="align: right"][/TD]
[TD="align: right"]161.2[/TD]

[TD="align: center"]26[/TD]
[TD="align: right"]154.9[/TD]

[TD="align: center"]27[/TD]
[TD="align: right"]149.2[/TD]

[TD="align: center"]28[/TD]
[TD="align: right"]16.2[/TD]

[TD="align: center"]29[/TD]
[TD="align: right"][/TD]
[TD="align: right"]320.3[/TD]

[TD="align: center"]30[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]31[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

</tbody>

Sheet4​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G11[/TH]
[TD="align: left"]=IF(F11="",SUM(F$10:F10)-SUM(G$10:G10),"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Anthea]

Yes! Thank you so much, Eric - that does exactly what I need it to do!

Kind Regards
Anthea

 

[Eric W]

Glad we could help!