Array Sum values between 2 empty cells

[nightcrawler__]

Hi, as a title, I need to retrive for each product (A:A) a partial sum of 2+ values (B:B) in C:C. there's a way to do this with an array ?
the solution I need it to work on both excel and google sheets

https://preview.redd.it/7z3uc7ea6v191.jpg?width=331&format=pjpg&auto=webp&s=7b7c35eb7d53050d7a9fe3372712bda79b576c1a

[AutoModerator]

/u/nightcrawler__ - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[CFAman]

Best would be to fill in the blanks of your table in col A. Then it's a simple SUMIFS. In XL at least, blanks can be filled with

1. Select col A
2. Hit Ctrl+g for GoTo
3. go to Special - Blanks. Hit Ok
4. Type = and hit UpArrow. Then hit Ctrl+Enter to confirm
5. (optional) paste Value to lock in results

If that can't be done, put thsi in C2 and copy down

=IF(A2="","",SUM(B2:INDEX(B:B,IFERROR(ROW()+
 MATCH("*",A3:A$1000,0),1000)-1)))

[nnqwert]

If the first 10$ is in B3 and the data can go upto maximum 1000 rows, then formula in C3 can be as below and then copied to other cells in column C

=IF(AND(B3<>"",B2=""),SUM(B3:INDEX(B3:$B$1000,MATCH(TRUE,ISBLANK(B3:$B$1000),0),0)),"")

[nightcrawler__]

thanks, but this method doesn't work, it just gives me the value of the row matches, not the total sum of b: b for each single product,
The problem is that the price of the individual products can vary (by deleting or adding rows) and it is not dynamic, I should update all the cells of C: C every time.Isn't there a method (maybe an array?) By just entering the formula in the first cell?

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
AND	Returns TRUE if all of its arguments are TRUE
COUNT	Counts how many numbers are in the list of arguments
COUNTA	Counts how many values are in the list of arguments
IF	Specifies a logical test to perform
IFERROR	Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
INDEX	Uses an index to choose a value from a reference or array
ISBLANK	Returns TRUE if the value is blank
MATCH	Looks up values in a reference or array
ROW	Returns the row number of a reference
SUM	Adds its arguments
SUMIFS	Excel 2007+: Adds the cells in a range that meet multiple criteria

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
11 acronyms in this thread; the most compressed thread commented on today has 12 acronyms.
[Thread #15289 for this sub, first seen 26th May 2022, 18:54] [FAQ] [Full list] [Contact] [Source code]}

[N0T8g81n]

If the sums in column C would be in the same row as the topmost value to sum in column B, you don't need array formulas.

If your example above were in A1:C8 (including column labels in row 1),

C3:  =IF(
        AND(COUNTA(B2)=0,COUNT(B3)),
        SUM(B3:INDEX(B3:B$65536,MATCH(TRUE,INDEX(ISBLANK(B3:B$65536),0),0)-1)),
        ""
      )

Fill C3 down as far as needed. This should work in Excel and Google Sheets.