sum between blank cells

I am building a inventory management worksheet. I receive packages which contain sub material of different weights. I am trying to make a sheet where i enter the sub weights of the package and it calculate the total from the first till the last entry.

I found this dynamic function to calculate sum between blank cells. the function only displays the result on the last cell before the blank cell but is applied to the entire column.As it shows the sum in the last cell i am not able to use the result for a sumifs function to generate a total. I want the sum to be showed in the first cell of each entry next to samsung and mts. Can someone help me with it?

formula =IFERROR(IF(ISBLANK(F8),SUMPRODUCT(INDEX(F:F,LOOKUP(2,1/ISBLANK(F$1:F7),ROW(F$1:F7))):F7),""),"")

2017-04-23 (2).png

right now it shows the sum at E16 & E21
i want it to show the sum at E7 & E18

thanks in advance

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.



To add a file to a post

coolmob welcome to the forum.

Edited: Came up with shorter formula.

This is the best I can come up with. It works with the example provided, (but .....?) It is an array formula entered in E7 and filled down. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

You're welcome. Thanks for the feedback.

Originally Posted by FlameRetired

coolmob welcome to the forum.

Edited: Came up with shorter formula.

This is the best I can come up with. It works with the example provided, (but .....?) It is an array formula entered in E7 and filled down. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

your earlier formula worked perfectly.
working formula

Formula:

Please Login or Register  to view this content.

the edited one you posted does not count after 4 entries. please fix this formula

thanks

I thought about this after you marked it solved, and I haven't looked at JohnTopley's solution, yet.

I referenced the incorrect variable for the K_value of SMALL in the earlier posts. My apologies.

The first formula should be: (note the offset in the rows of COUNTIF($F$6:F6,""))

Formula:

Please Login or Register  to view this content.

The edited formula should still work with that same correction.

Formula:

Please Login or Register  to view this content.

I can't tell which formula you want fixed.

Go with John's approach. It's much simpler and easier to maintain.

The reference to column H in JohnTopley's formula is to the helper column. It is the range for criteria to evaluate and the criteria itself. They are needed for the SUMIF function to conditionally add numbers in column F.

Those conditions referencing column C are in the helper column formula.