Index Match and Sum??

[gerald1nix]

I have writer's block. Any help is greatly appreciated.
Attempting to match titles from column C, any matched whether one entry or 100 entries then sum those numbers from column D and have that sum in column F. Doing the same for column C, E and G.
[TABLE="width: 500"]
<tbody>[TR]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]title[/TD]
[TD]2014[/TD]
[TD]2024[/TD]
[TD]2014 Sum[/TD]
[TD]2024 Sum[/TD]
[TD]Growth %[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]40[/TD]
[TD]45[/TD]
[TD]180[/TD]
[TD]195[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]60[/TD]
[TD]65[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]80[/TD]
[TD]85[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]30[/TD]
[TD]35[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]50[/TD]
[TD]55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]5[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]15[/TD]
[TD]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]25[/TD]
[TD]30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]35[/TD]
[TD]40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]45[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]100[/TD]
[TD]110[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]200[/TD]
[TD]210[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]title[/TD]
[TD]

2014​

[/TD]
[TD]

2024​

[/TD]
[TD]

2014​

[/TD]
[TD]

2024​

[/TD]
[TD]Growth %[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]A[/TD]
[TD]

40​

[/TD]
[TD]

45​

[/TD]
[TD]

180​

[/TD]
[TD]

195​

[/TD]
[TD]

8.33%​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]A[/TD]
[TD]

60​

[/TD]
[TD]

65​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]A[/TD]
[TD]

80​

[/TD]
[TD]

85​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]B[/TD]
[TD]

10​

[/TD]
[TD]

15​

[/TD]
[TD]

90​

[/TD]
[TD]

105​

[/TD]
[TD]

16.67%​

[/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]B[/TD]
[TD]

30​

[/TD]
[TD]

35​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD]B[/TD]
[TD]

50​

[/TD]
[TD]

55​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]C[/TD]
[TD]

5​

[/TD]
[TD]

10​

[/TD]
[TD]

125​

[/TD]
[TD]

150​

[/TD]
[TD]

20.00%​

[/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD]C[/TD]
[TD]

15​

[/TD]
[TD]

20​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

11​

[/TD]
[TD]C[/TD]
[TD]

25​

[/TD]
[TD]

30​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

12​

[/TD]
[TD]C[/TD]
[TD]

35​

[/TD]
[TD]

40​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

13​

[/TD]
[TD]C[/TD]
[TD]

45​

[/TD]
[TD]

50​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

14​

[/TD]
[TD]D[/TD]
[TD]

100​

[/TD]
[TD]

110​

[/TD]
[TD]

300​

[/TD]
[TD]

320​

[/TD]
[TD]

6.67%​

[/TD]
[/TR]
[TR]
[TD]

15​

[/TD]
[TD]D[/TD]
[TD]

200​

[/TD]
[TD]

210​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

f3=IF(COUNTIFS($C$3:$C3,$C3)=1,SUMPRODUCT(($C$3:$C$15=$C3)*($D$2:$E$2=F$2)*($D$3:$E$15)),"") copy doww and accross

h3 =IF(COUNTIF($C$3:$C3,$C3)=1,(G3-F3)/F3,"")

 

[FDibbins]

A shorter way to do the sum...
F3=IF($C3=$C2,"",SUMIF($C$3:$C$15,$C3,D$3:D$15))
copied down and across
For the %
=IF(F3="","",(G3-F3)/F3)

 

[Peter_SSs]

Welcome to the MrExcel board!

If your data is sorted by column A like your sample, then yet another option:

Formula in F3 (adjust ranges to suit with the final row being at least 1 row below the last data) is copied across to G and down.
H3, copied down.

Book1
	C	D	E	F	G	H
1	title	2014	2024	2014 Sum	2024 Sum	Growth %
2	A	40	45	180	195	8.33%
3	A	60	65
4	A	80	85
5	B	10	15	90	105	16.67%
6	B	30	35
7	B	50	55
8	C	5	10	125	150	20.00%
9	C	15	20
10	C	25	30
11	C	35	40
12	C	45	50
13	D	100	110	300	320	6.67%
14	D	200	210
15
Sums

Cell Formulas
Range	Formula
F2	=IF($C2=$C1,"",SUM(D2:D$15)-SUM(F3:F$15))
H2	=IF(G2="","",G2/F2-1)

 

[gerald1nix]

Thanks for the responses. I tried the variations and could not get them to work. Here is a clip of what I am working on. I use excel for viz purposes and this task is really stretching me beyond my understanding of formula use. The total sheet is 24966 columns long and the tools listed in column C have hundreds of variations. I know my growth formula. My problem, the sum of column H which goes in J, and the sum of column I which goes in K - both based on the type of tool used in Column C. What I have done so far, see below, is all by using a filter in column C and manually getting the sum that way.
Many thanks again for any help.

C D E F G H I J K L
[TABLE="width: 703"]
<colgroup><col width="228" style="width: 171pt; mso-width-source: userset; mso-width-alt: 8106;"> <col width="90" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3185;"> <col width="62" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2190;"> <col width="94" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3356;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3726;"> <col width="64" style="width: 48pt;"> <col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3640;"> <col width="64" style="width: 48pt;" span="3"> <tbody>[TR]
[TD="width: 228, bgcolor: transparent"]Abrasive stones[/TD]
[TD="width: 90, bgcolor: transparent"]N[/TD]
[TD="width: 62, bgcolor: transparent, align: right"]15[/TD]
[TD="width: 94, bgcolor: transparent, align: right"]10[/TD]
[TD="width: 105, bgcolor: transparent, align: right"]5[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]567[/TD]
[TD="width: 102, bgcolor: transparent, align: right"]676[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]4691[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]5246[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent, align: right"]11.83%[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Abrasive stones[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]91[/TD]
[TD="bgcolor: transparent, align: right"]97[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Abrasive stones[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]20[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent, align: right"]705[/TD]
[TD="bgcolor: transparent, align: right"]804[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Abrasive stones[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]475[/TD]
[TD="bgcolor: transparent, align: right"]517[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Abrasive stones[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]1612[/TD]
[TD="bgcolor: transparent, align: right"]1824[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Abrasive stones[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]25[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent, align: right"]916[/TD]
[TD="bgcolor: transparent, align: right"]1014[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Abrasive stones[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]325[/TD]
[TD="bgcolor: transparent, align: right"]314[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Absorbent booms[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent, align: right"]464[/TD]
[TD="bgcolor: transparent, align: right"]500[/TD]
[TD="bgcolor: transparent, align: right"]1302[/TD]
[TD="bgcolor: transparent, align: right"]1299[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Absorbent booms[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]30[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]30[/TD]
[TD="bgcolor: transparent, align: right"]838[/TD]
[TD="bgcolor: transparent, align: right"]799[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Absorbent pillows[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]25[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]20[/TD]
[TD="bgcolor: transparent, align: right"]978[/TD]
[TD="bgcolor: transparent, align: right"]1027[/TD]
[TD="bgcolor: transparent, align: right"]978[/TD]
[TD="bgcolor: transparent, align: right"]1027[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Accelerometers[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]61[/TD]
[TD="bgcolor: transparent, align: right"]69[/TD]
[TD="bgcolor: transparent, align: right"]21636[/TD]
[TD="bgcolor: transparent, align: right"]23964[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Accelerometers[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]145[/TD]
[TD="bgcolor: transparent, align: right"]35[/TD]
[TD="bgcolor: transparent, align: right"]110[/TD]
[TD="bgcolor: transparent, align: right"]5029[/TD]
[TD="bgcolor: transparent, align: right"]5355[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Accelerometers[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]20[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]20[/TD]
[TD="bgcolor: transparent, align: right"]545[/TD]
[TD="bgcolor: transparent, align: right"]548[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Accelerometers[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]170[/TD]
[TD="bgcolor: transparent, align: right"]60[/TD]
[TD="bgcolor: transparent, align: right"]110[/TD]
[TD="bgcolor: transparent, align: right"]3483[/TD]
[TD="bgcolor: transparent, align: right"]4095[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Accelerometers[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]218[/TD]
[TD="bgcolor: transparent, align: right"]264[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Accelerometers[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]35[/TD]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent, align: right"]20[/TD]
[TD="bgcolor: transparent, align: right"]770[/TD]
[TD="bgcolor: transparent, align: right"]919[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Accelerometers[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]226[/TD]
[TD="bgcolor: transparent, align: right"]249[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Accelerometers[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]92[/TD]
[TD="bgcolor: transparent, align: right"]100[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Accelerometers[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]405[/TD]
[TD="bgcolor: transparent, align: right"]125[/TD]
[TD="bgcolor: transparent, align: right"]280[/TD]
[TD="bgcolor: transparent, align: right"]11041[/TD]
[TD="bgcolor: transparent, align: right"]12313[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Accelerometers[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]171[/TD]
[TD="bgcolor: transparent, align: right"]52[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Access servers[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]105[/TD]
[TD="bgcolor: transparent, align: right"]65[/TD]
[TD="bgcolor: transparent, align: right"]40[/TD]
[TD="bgcolor: transparent, align: right"]3489[/TD]
[TD="bgcolor: transparent, align: right"]4152[/TD]
[TD="bgcolor: transparent, align: right"]5644[/TD]
[TD="bgcolor: transparent, align: right"]6525[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Access servers[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]20[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent, align: right"]903[/TD]
[TD="bgcolor: transparent, align: right"]993[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Access servers[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]30[/TD]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent, align: right"]1252[/TD]
[TD="bgcolor: transparent, align: right"]1380[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Acoustic sensors[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]61[/TD]
[TD="bgcolor: transparent, align: right"]69[/TD]
[TD="bgcolor: transparent, align: right"]4667[/TD]
[TD="bgcolor: transparent, align: right"]5321[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Acoustic sensors[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]170[/TD]
[TD="bgcolor: transparent, align: right"]60[/TD]
[TD="bgcolor: transparent, align: right"]110[/TD]
[TD="bgcolor: transparent, align: right"]3483[/TD]
[TD="bgcolor: transparent, align: right"]4095[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Acoustic sensors[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[TD="bgcolor: transparent, align: right"]302[/TD]
[TD="bgcolor: transparent, align: right"]290[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Acoustic sensors[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]20[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent, align: right"]821[/TD]
[TD="bgcolor: transparent, align: right"]867[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Acoustic testing rooms[/TD]
[TD="bgcolor: transparent"]N[/TD]
[TD="bgcolor: transparent, align: right"]190[/TD]
[TD="bgcolor: transparent, align: right"]60[/TD]
[TD="bgcolor: transparent, align: right"]130[/TD]
[TD="bgcolor: transparent, align: right"]4379[/TD]
[TD="bgcolor: transparent, align: right"]4999[/TD]
[TD="bgcolor: transparent, align: right"]4379[/TD]
[TD="bgcolor: transparent, align: right"]4999[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

 

[gerald1nix]

Thanks for the responses. I am struggling with this one, I am more of a design/viz person. The big concern is how do I sum column H with the answer in column J based upon the types of tools in column C, same goes for sum of column I going into column K based upon the tools in column C. I hope this helps and thanks in advance once again.


C D E F G H I J K L
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Abrasive Stones[/TD]
[TD]N[/TD]
[TD]15[/TD]
[TD]10[/TD]
[TD]5[/TD]
[TD]567[/TD]
[TD]676[/TD]
[TD]4691[/TD]
[TD]5246[/TD]
[TD]11.83%[/TD]
[/TR]
[TR]
[TD]Abrasive Stones[/TD]
[TD]N[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]91[/TD]
[TD]97[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Abrasive Stones[/TD]
[TD]N[/TD]
[TD]20[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]705[/TD]
[TD]804[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Abrasive Stones[/TD]
[TD]N[/TD]
[TD]10[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]475[/TD]
[TD]517[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Abrasive Stones[/TD]
[TD]N[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1612[/TD]
[TD]1824[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Abrasive Stones[/TD]
[TD]N[/TD]
[TD]25[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD]916[/TD]
[TD]1014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Abrasive Stones[/TD]
[TD]N[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]325[/TD]
[TD]314[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Absorbent booms[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]15[/TD]
[TD]5[/TD]
[TD]10[/TD]
[TD]464[/TD]
[TD]500[/TD]
[TD]1302[/TD]
[TD]1299[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Absorbent booms[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]30[/TD]
[TD]0[/TD]
[TD]30[/TD]
[TD]838[/TD]
[TD]799[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Absorbent booms[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]25[/TD]
[TD]5[/TD]
[TD]20[/TD]
[TD]978[/TD]
[TD]1027[/TD]
[TD]978[/TD]
[TD]1027[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Accelerometers[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]61[/TD]
[TD]69[/TD]
[TD]21636[/TD]
[TD]23964[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Accelerometers[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]145[/TD]
[TD]35[/TD]
[TD]110[/TD]
[TD]5029[/TD]
[TD]5355[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Accelerometers[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]20[/TD]
[TD]0[/TD]
[TD]20[/TD]
[TD]545[/TD]
[TD]548[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Accelerometers[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]170[/TD]
[TD]60[/TD]
[TD]110[/TD]
[TD]3483[/TD]
[TD]4095[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Accelerometers[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]10[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]218[/TD]
[TD]264[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Accelerometers[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]35[/TD]
[TD]15[/TD]
[TD]20[/TD]
[TD]770[/TD]
[TD]919[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Accelerometers[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]226[/TD]
[TD]249[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Accelerometers[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]92[/TD]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Accelerometers[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]405[/TD]
[TD]125[/TD]
[TD]280[/TD]
[TD]11041[/TD]
[TD]12313[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Accelerometers[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]171[/TD]
[TD]52[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Access Servers[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]105[/TD]
[TD]65[/TD]
[TD]40[/TD]
[TD]3489[/TD]
[TD]4152[/TD]
[TD]5644[/TD]
[TD]6525[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Access Servers[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]20[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]903[/TD]
[TD]993[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Access Servers[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]30[/TD]
[TD]15[/TD]
[TD]15[/TD]
[TD]1252[/TD]
[TD]1380[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Acoustic sensors[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]61[/TD]
[TD]69[/TD]
[TD]4667[/TD]
[TD]5321[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 228"]
<tbody>[TR]
[TD]Acoustic sensors[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]N[/TD]
[TD]170[/TD]
[TD]60[/TD]
[TD]110[/TD]
[TD]3483[/TD]
[TD]4095[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Acoustic sensors[/TD]
[TD]N[/TD]
[TD]10[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD]302[/TD]
[TD]290[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Acoustic sensors[/TD]
[TD]N[/TD]
[TD]20[/TD]
[TD]5[/TD]
[TD]15[/TD]
[TD]821[/TD]
[TD]867[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FDibbins]

After adjusting my ranges, the formula I suggested in post #3 works...
=IF($C1=$C2,"",SUMIF($C$2:$C$28,$C3,H$2:H$28))
copied down and across
(your 1302 answer is wrong btw, should be 2280)

 

[Peter_SSs]

After adjusting the ranges, the formulas I suggested in post # 4 also work. Below I have made the ranges considerably longer than the sample data.

Book1
	C	D	E	F	G	H	I	J	K	L
2	Abrasive stones	N	15	10	5	567	676	4691	5246	11.83%
3	Abrasive stones	N	0	0	0	91	97
4	Abrasive stones	N	20	10	10	705	804
5	Abrasive stones	N	10	5	5	475	517
6	Abrasive stones	N				1612	1824
7	Abrasive stones	N	25	10	15	916	1014
8	Abrasive stones	N	5	0	5	325	314
9	Absorbent booms	N	15	5	10	464	500	1302	1299	-0.23%
10	Absorbent booms	N	30	0	30	838	799
11	Absorbent pillows	N	25	5	20	978	1027	978	1027	5.01%
12	Accelerometers	N	5	0	0	61	69	21636	23964	10.76%
13	Accelerometers	N	145	35	110	5029	5355
14	Accelerometers	N	20	0	20	545	548
15	Accelerometers	N	170	60	110	3483	4095
16	Accelerometers	N	10	5	5	218	264
17	Accelerometers	N	35	15	20	770	919
18	Accelerometers	N	5	0	5	226	249
19	Accelerometers	N	5	0	0	92	100
20	Accelerometers	N	405	125	280	11041	12313
21	Accelerometers	N	5	0	5	171	52
22	Access servers	N	105	65	40	3489	4152	5644	6525	15.61%
23	Access servers	N	20	10	10	903	993
24	Access servers	N	30	15	15	1252	1380
25	Acoustic sensors	N	5	0	0	61	69	4667	5321	14.01%
26	Acoustic sensors	N	170	60	110	3483	4095
27	Acoustic sensors	N	10	0	10	302	290
28	Acoustic sensors	N	20	5	15	821	867
29	Acoustic testing rooms	N	190	60	130	4379	4999	4379	4999	14.16%
30
Sums (2)

Cell Formulas
Range	Formula
J2	=IF($C2=$C1,"",SUM(H2:H$100)-SUM(J3:J$100))
L2	=IF(K2="","",K2/J2-1)

(your 1302 answer is wrong btw, should be 2280)

Ford, that depends on which version of the sample data you are looking at.

 

[FDibbins]

...Ford, that depends on which version of the sample data you are looking at. ...

True. I used the sample from post #6 (the 1 with 3 absorbent booms). Didn't check post 6 against post 5 to see if they matched

 

[Peter_SSs]

Didn't check post 6 against post 5 to see if they matched

I wouldn't have either if you hadn't commented on the error. So I went trying to figure out how the OP came up with those numbers & that's when I discovered the difference.