SOLVED

Not sure how to structure "COUNTSIF" formula or if it is the right formula to use.

%3CLINGO-SUB%20id%3D%22lingo-sub-3195764%22%20slang%3D%22en-US%22%3ENot%20sure%20how%20to%20structure%20%22COUNTSIF%22%20formula%20or%20if%20it%20is%20the%20right%20formula%20to%20use.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3195764%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20COUNTSIF%20in%20Cell%20F160%20to%20look%20for%20the%20same%20name%20found%20in%20Cell%20E160%20against%20Column%20A%2C%20rows%203-150.%26nbsp%3B%20Once%20identified%2C%20looking%20for%20the%20number%20found%20in%20Column%20Z%20of%20the%20same%20row%20(3%20-150)%20and%20adding%20the%20sum%20to%20cell%20F160.%26nbsp%3B%20I%20repeat%20the%20process%20for%20each%20name%20that%20I%20am%20trying%20to%20easily%20add%20their%20numbers%20together.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20for%20advise%20and%2For%20a%20solution%20as%20I%20am%20going%20bald%20after%20scratching%20my%20head%20trying%20to%20figure%20this%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EMonymgr%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3195764%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3195826%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20sure%20how%20to%20structure%20%22COUNTSIF%22%20formula%20or%20if%20it%20is%20the%20right%20formula%20to%20use.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3195826%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1285630%22%20target%3D%22_blank%22%3E%40Monymgr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20SUMIF%20in%20F160%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DSUMIF(%24A%243%3A%24A%24150%2C%20E160%2C%20%24Z%243%3A%24Z%24150)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20can%20be%20filled%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3195893%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20sure%20how%20to%20structure%20%22COUNTSIF%22%20formula%20or%20if%20it%20is%20the%20right%20formula%20to%20use.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3195893%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much!!!%20It%20works!!!!!!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20can%20go%20back%20to%20growing%20my%20hair%2C%20lol%3C%2FLINGO-BODY%3E
New Contributor

I am using COUNTSIF in Cell F160 to look for the same name found in Cell E160 against Column A, rows 3-150.  Once identified, looking for the number found in Column Z of the same row (3 -150) and adding the sum to cell F160.  I repeat the process for each name that I am trying to easily add their numbers together. 

 

Looking for advise and/or a solution as I am going bald after scratching my head trying to figure this out.

 

Thanks,

Monymgr

2 Replies
best response confirmed by Monymgr (New Contributor)
Solution

@Monymgr 

Try SUMIF in F160:

 

=SUMIF($A$3:$A$150, E160, $Z$3:$Z$150)

 

This can be filled down.

Thank you so much!!! It works!!!!!!

I can go back to growing my hair, lol