Sum consecutive cells in excel using the upper and lower text limit as criteria

**MyStix01** · 09-18-2018, 02:31 AM

Hi,

I'm hoping someone could help me out. I need a formula under column C in which it will automatically sum up the values on cell B using A as criteria.

What I think is, the formula should use the names as limit, like for example, if the formula detects that the next cell is a different text, it will then sum up values on column B in where the value in column A is the same until the text differs again.

Hope that makes sense.

The thing is I just want it to look exactly as how it is on the sheet but without me having had to manually sum up the amounts.

I hope this is possible. Thank you so much!

**shukla.ankur281190** · 09-18-2018, 02:35 AM

Try

L3

Formula:

Please Login or Register  to view this content.

Drag down

**Glenn Kennedy** · 09-18-2018, 02:38 AM

Use:
=SUMIF(I:I,I3,J:J)

or, to get your exact expected results:
=IF(SUMIF(I:I,I3,J:J)=SUMIF($I$3:I3,$I3,J$3:J3),SUMIF(I:I,I3,J:J),"")

**MyStix01** · 09-18-2018, 03:10 AM

Hi Glenn and Shukla,

Thank you for responding, I think I uploaded an incorrect file. Please see attached updated one. Glenn's formula works if the names would not repeat somewhere below, however the file I'm working on would repeat the names across.

Sorry of this and thank you so much!

**FlameRetired** · 09-18-2018, 03:15 AM

Similar

Formula:

Please Login or Register  to view this content.

**samba_ravi** · 09-18-2018, 03:24 AM

c2=IF(A2=A3,"",SUMIF(A$2:A2,A2,B$2:B2)-SUMIF(A$1:A1,A1,C$1:C1))
Try this and copy towards down

**FlameRetired** · 09-18-2018, 03:25 AM

Shadowing the expected output in C this proposes a helper column in D. D2 and down

Formula:

Please Login or Register  to view this content.

In E2 and down

Formula:

Please Login or Register  to view this content.

**shukla.ankur281190** · 09-18-2018, 03:30 AM

or try

C2

Formula:

Please Login or Register  to view this content.

**XLent** · 09-18-2018, 03:33 AM

The below should suffice:

Formula:

Please Login or Register  to view this content.

The above simply uses the logic that the answer is the total of Column B {at given row} less any previously calculated sub total(s) in Column C {up to and including prior row}.

Answers mirror expected, and all pretty straightforward.

**MyStix01** · 09-18-2018, 03:55 AM

Wow, thank you all for the responses! I guess the last formula is straighforward, hence I'd use it. Thank you all!

Sum consecutive cells in excel using the upper and lower text limit as criteria

LinkBack

Thread Tools

Rate This Thread

Display

Sum consecutive cells in excel using the upper and lower text limit as criteria

Re: Sum consecutive cells in excel using the upper and lower text limit as criteria

Re: Sum consecutive cells in excel using the upper and lower text limit as criteria

Re: Sum consecutive cells in excel using the upper and lower text limit as criteria

Re: Sum consecutive cells in excel using the upper and lower text limit as criteria

Re: Sum consecutive cells in excel using the upper and lower text limit as criteria

Re: Sum consecutive cells in excel using the upper and lower text limit as criteria

Re: Sum consecutive cells in excel using the upper and lower text limit as criteria

Re: Sum consecutive cells in excel using the upper and lower text limit as criteria

Re: Sum consecutive cells in excel using the upper and lower text limit as criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] upper and lower limit index search

Copy and insert row below within fixed upper limit and dynamic lower limit

Finding a value within an upper and lower limit

[SOLVED] I need to creat a IF formula that has a upper and lower limit.

[SOLVED] find the lower and upper limit if data is in between on that limit

Separate consecutive lower then upper characters

Upper and lower limit lines on chart

Bookmarks

Bookmarks

Posting Permissions