Add Sum total only when reaching bottom of row based on value in another column

[TTXS]

Hello, I have a sheet with column A has two values, say Incoming and Outgoing. I have column B with the numbers. I want to add Total Incoming and Total Outgoing in column C. Incoming/Outgoing is sorted. So let’s say I have 10 rows of incoming value, then I want total in cell C11 (first row is the header). Then I have 5 rows of Outgoing, then the total would be in cell C16.

The thing is the number of incoming/outgoing could change daily. So tomorrow the total may need to be cell 20 and 25. How can I use a VBA to auto check the last row with Incoming or Outgoing in column A and create a Sum total? Thanks

 

[awoohaw]

welcome to the forum. I think it would help the forum (especially me) if you provided a sample of what your data looks like on one day. Also, expected results in column C would be helpful.

 

[Jeffrey Mahoney]

First, welcome.

Are you trying to create a running total of Incoming and Outgoing? I would use Sumifs and combine it with an IF statement to only give you a summary in Column B when you need it. I wish you could post a sample of the sheet.

Maybe something like pasted in Cell B2:
=IF($A2<>$A3,SUMIFS($C$1:$C2,$A$1:$A2,$A2),"")

 

[awoohaw]

maybe this:

Book1
	A	B	C
1	Type	Amt	Total
2	Incomming	22
3	Incomming	23
4	Incomming	18
5	Incomming	28
6	Incomming	16
7	Incomming	12	119
8	Outgoing	29
9	Outgoing	22
10	Outgoing	17
11	Outgoing	20	88
12	Incomming	12
13	Incomming	23
14	Incomming	24	59
15	Outgoing	21
16	Outgoing	29
17	Outgoing	21
18	Outgoing	25
19	Outgoing	28	124
Sheet2

Cell Formulas
Range	Formula
C2:C19	C2	=IF(A3<>A2,SUM($B$2:B2)-SUM($C$1:$C1),"")

 

[TTXS]

Thank you. That’s what I need - the IF statement of A3<>A2. I didn’t think of that, but it worked for my purpose. Thank you!

 

[awoohaw]

Thank you. That’s what I need - the IF statement of A3<>A2. I didn’t think of that, but it worked for my purpose. Thank you!

My pleasure.
Best Wishes!