Sum totals in different cells in Excel

[raajnabriz]

Dear Sir,

I need an Excel formula to get the total of all the sums in different cells in different columns, eg; in column A [in different cells] I have labeled it as Total and the sum is in column B adjacent to each total [in different cells].

Please give me an excel formula

Thank you,
Raaj.

2013	2,000.00		2019	855.04		TOTAL:
2018	2,000.00		2020	4,761.00
TOTAL:	4,000.00		2021	84,566.32
			2022	16,721.00
			TOTAL:	106,903.36
2014	500.00
2015	150.00
2022	15,791.00		2017	2,000.00
TOTAL:	16,441.00		2018	2,000.00
			TOTAL:	4,000.00
2021	40,000.18
TOTAL:	40,000.18		2022	5,000.00
			TOTAL:	5,000.00
2022	9,500.00
TOTAL:	9,500.00		2016	498.87
			2017	548.16
			TOTAL:	1,047.03
2017	125.00
2019	2,163.00
TOTAL:	2,288.00		2016	150,262.12
			2017	1,987,394.05
			2018	43,028.75
2011	1,530.00		2019	287,432.54
2020	178.50		TOTAL:	2,468,117.46
TOTAL:	1,708.50
			2013	500.00
2014	3,000.00		2018	5,821.19
2017	3,000.00		TOTAL:	6,321.19
TOTAL:	6,000.00
			2021	6,385.90
2012	4,500.00		2022	207.00
2013	1,500.00		TOTAL:	6,592.90
2015	11,900.00
TOTAL:	17,900.00
			2016	11,069.80
			2017	5,940.00
2019	2,695.80		TOTAL:	17,009.80
2020	132.72
TOTAL:	2,828.52
			2015	1,500.00
			TOTAL:	1,500.00

 

[JvdV]

Is this sample data showing data in columnd D:E aswell? Or did you intent that to be part of column A:B? If the latter, try:

=SUMIF(A:A,"TOTAL:",B:B)

If the former, try:

=SUMIF(A:D,"TOTAL:",B:E)

 

[raajnabriz]

Is this sample data showing data in columnd D:E aswell? Or did you intent that to be part of column A:B? If the latter, try:

=SUMIF(A:A,"TOTAL:",B:B)

If the former, try:

=SUMIF(A:D,"TOTAL:",B:E)

Thank you

*JvdV​

The 2nd formula solved the issue at hand.

Thank you in millions.

Raaj.