Summming information in adjacent cells with only one identifier

Frank Weir · Feb 5, 2016

Hi: I am trying to link to an inventory report that is based on several different warehouse locations. This may be 1 to 5 in number. The product identifier is only on the top warehouse line. Want to get total item inventory amount.
Sample data below: Any idea's?

Stock code	Description	Supp Cls U/M	Cum CC	Wh Bin	ABC	On han	Ave cost	Value	Total mass

142	Product A	2405 CS	CS	AV		241	14.64	3528.24	5000.75
				TO		1728	14.64	25297.92	35856
				VC		1536	14.64	22487.04	31872
		Stock code total :	total :			3505		51313.2	72728.75

144	Product B	2405 CS	CS	AE		6	13.17	79.02	124.5
				AV	D	120	13.17	1580.4	2490
				TO		528	13.17	6953.76	10956
				VC		192	13.17	2528.64	3984
		Stock code total :	total :			846		11141.82	17554.5

145	Product C	2501 CS	CS	AE		65	13.16	855.4	1007.5
				AV		54	13.16	710.64	837
		Stock code total :	total :			119		1566.04	1844.5

146	Product D	2501 CS	CS	AV		60	16.74	1004.4	930

147	Product E	2501 CS	CS	AE		30	13.51	405.3	465
				AV		36	13.51	486.36	558
		Stock code total :	total :			66		891.66	1023

navic · Feb 7, 2016

Frank Weir said:
Want to get total item inventory amount.

If I understood you well, (for Excel 2013) attempt to use Subtotal from Data tab in Excel. It also uses Conditional Formatting to highlight the row Total Sum
The formula for the CF is as follows

Code:

=RIGHT($A2;5)="Total"

See attachment file

Stock code entered in each cell

Summming information in adjacent cells with only one identifier

Frank Weir

New member

navic

New member

Attachments