SUM for unknown number of set of rows

Dear all,

I've had searched the forum but couldn't locate the solution for my situation.

Situation: Huge amount of data. Set of unknown number of rows, e.g one set has 6 rows, 10 row, 14 rows, etc. Each set is separated by a row containing blank and date. How can I define a formula so that I can quickly sum values. Please see the screenshot below.

Excel_1.PNG



It would be a night mare if I manually enter the sum formula for 1 million records like that. Any help is appreciated !

Regards,
AL

8

Hi, welcome to the forum

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

(dont forget the sample answers)

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

I can't see your image.

One way...

Data Range

	E	F
1	61
2	10
3	81
4		152
5	22
6	52
7		74
8	82
9		82
10	86
11	93
12	55
13	27
14		261
15	------	------

This formula entered in F2 and copied down:

=IF(E2="",SUM(E$1:E2)-SUM(F$1:F1),"")

If you really do have a million rows worth of data this may be slow to calculate.

Thanks for the file.

(looks like you forgot the sample answers?)

Did you try Tony's suggestion yet?

On the suggestion - or including sample answers - or both?
lol

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Good stuff, thanks for the feedback

You're welcome. Thanks for the feedback!