How to sum values from one column that have the same value in another column

Question

Hello All,First time here, so apologies if this is really obvious, but how can I use Excel to sum the Total Hours for each individual ID Code in the example below:&nbsp;ID CodeTotal Hours110255705450.511019717763110239591631102395911111022381763110263558631102896946311028969411110250031111102748881111018467512711018467563110184675111102500211111025004811110283933631102839331111022626863110277669631102833126311028331211110283700631102837001111026293063110262930111102838706311028387011110285556631102409271111017049945011028465763110284657111102900486311029004811eg for ID Code&nbsp;110289694 I want to return 74, for ID Code&nbsp;110184675 I want to return 201, for ID Code&nbsp;110170499 I want to return 450.&nbsp;Thanks very much for your help.&nbsp;

riny_van_eekelen · Answer

MRS16&nbsp;Try this:The attached file contains a working example.

abiola1 · Answer

MRS16&nbsp;
&nbsp;
Alternatively, you can use SUMPRODUCT to do the task. See also the attached file

&nbsp;

sergeibaklan · Answer

MRS16&nbsp;
As variant you may use PivotTable

Forum Discussion

How to sum values from one column that have the same value in another column

3 Replies

Resources

ID Code	Total Hours
110255705	450.5
110197177	63
110239591	63
110239591	11
110223817	63
110263558	63
110289694	63
110289694	11
110250031	11
110274888	11
110184675	127
110184675	63
110184675	11
110250021	11
110250048	11
110283933	63
110283933	11
110226268	63
110277669	63
110283312	63
110283312	11
110283700	63
110283700	11
110262930	63
110262930	11
110283870	63
110283870	11
110285556	63
110240927	11
110170499	450
110284657	63
110284657	11
110290048	63
110290048	11