Please see attachment
Trying to match names and then count numerical value for each name for cumulative total
example: column A, Row 2: name “A”,
How do I match A2 name “A”, to column AN, then add up all the numbers in column AM that match A2 name “A” and display in B2, I have added all the correct data in DA:D9, so the user is able to verify formula : : : ; … … LO Matching trying to find accumulative count 08-13-2019.ods.
Thank you in advance
Hello,
the function of column AN is not clear to me since it has the same content as colum A of the respective row. Your formulas could read:
Cell B2: =SUMIFS(AM$14:AM$90;A$14:A$90;A2)
Cell B3: =SUMIFS(AM$14:AM$90;A$14:A$90;A3)
Cell B4: =SUMIFS(AM$14:AM$90;A$14:A$90;A4)
Cell B5: =SUMIFS(AM$14:AM$90;A$14:A$90;A5)
Cell B6: =SUMIFS(AM$14:AM$90;A$14:A$90;A6)
Cell B7: =SUMIFS(AM$14:AM$90;A$14:A$90;A7)
Cell B8: =SUMIFS(AM$14:AM$90;A$14:A$90;A8)
Cell B9: =SUMIFS(AM$14:AM$90;A$14:A$90;A9)
Note:
If you want to stick with column AN replace A$14:A$90 by AN$14:AN$90 in the second argument of all formulas above.
See reworked sheet:
If the answer is correct or helped you to fix your problem, please click the check mark (
) next to the answer.
SPECTACULAR !!! TY!!!