Ask Your Question
0

cCalc How do I match name and count all cells with corresponding name

asked 2019-08-13 18:09:24 +0200

JG101 gravatar image

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 : : : ; .. .. C:\fakepath\LO Matching trying to find accumulative count 08-13-2019.ods.

Thank you in advance

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-08-13 19:46:33 +0200

Opaque gravatar image

updated 2019-08-13 19:52:23 +0200

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:

C:\fakepath\SUMIFMatching.ods

If the answer is correct or helped you to fix your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more

Comments

SPECTACULAR !!!! TY!!!!!

JG101 gravatar imageJG101 ( 2019-08-13 20:10:04 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-08-13 18:09:24 +0200

Seen: 20 times

Last updated: Aug 13