Match and Sum
 

I am trying to get a sum total upon matching conditions (Example)

B6 = CL Type
E6 = Number of Letters

in cell B6 there will be one of 4 selections (ENC Letters, ENC BR Letters, V
ENC Letters, ALL Letters)

What I would like to happen is when I have ENC Letters in B6,B10,B12 & B15 I
would like it to add those totals only while the other cells will be added
according to how they match.

Credit Letter Type Requestor Number of Letters

ENC Letters GH 54
ENC BR Letters TS 32
V ENC Letters JS 19
ALL Letters GH 12
ENC Letters TS 185
ENC BR Letters JS 95
V ENC Letters GH 64
ALL Letters TS 44
ENC Letters JS 88
ENC BR Letters GH 76
V ENC Letters TS 106
ALL Letters JS 212

Totals:
ENC Letters 327 total of all ENC Letters (onlu)
ENC BR Letters 203 total of all ENC BR Letters (Only)
V ENC Letters 189 total of all V ENC Letters (Only)
ALL Letters 268 total of all ALL Letters (Only)

I hope this makes sense, thank you for your help.

Match and Sum
 

Never mind , I have it.

I'm using a sumif (example)
=SUMIF(A7:A18,A7,C7:C18)

to those who would have helped...thank you.

"tryn2learn" wrote:

I am trying to get a sum total upon matching conditions (Example)

B6 = CL Type
E6 = Number of Letters

in cell B6 there will be one of 4 selections (ENC Letters, ENC BR Letters, V
ENC Letters, ALL Letters)

What I would like to happen is when I have ENC Letters in B6,B10,B12 & B15 I
would like it to add those totals only while the other cells will be added
according to how they match.

Credit Letter Type Requestor Number of Letters

ENC Letters GH 54
ENC BR Letters TS 32
V ENC Letters JS 19
ALL Letters GH 12
ENC Letters TS 185
ENC BR Letters JS 95
V ENC Letters GH 64
ALL Letters TS 44
ENC Letters JS 88
ENC BR Letters GH 76
V ENC Letters TS 106
ALL Letters JS 212

Totals:
ENC Letters 327 total of all ENC Letters (onlu)
ENC BR Letters 203 total of all ENC BR Letters (Only)
V ENC Letters 189 total of all V ENC Letters (Only)
ALL Letters 268 total of all ALL Letters (Only)

I hope this makes sense, thank you for your help.