Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |