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

[Monymgr]

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 · Accepted solution]

@Monymgr 

Try SUMIF in F160:

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

This can be filled down.

[#3]

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

I can go back to growing my hair, lol