Need help with VBA

  • Thread starter Need help with sumif
  • Start date
N

Need help with sumif

I'm not sure If I could explain this easy but let me try


on sheet1 there are name list
on sheet2 there are list of names with their earning in $(Name could appear
more than once)
on sheet3 I want to find all cells that contains (David) in sheet2 & what
ever $
that's next to it add it when I click a command button

If this doesn't explain enough maybe I could attach the sample let me know
Thanks !!!!
 
D

davesexcel

this could work

=SUMIF(A1:B6,C1,B1:B6)
A1:B6 is the total range
C1 is the criteria
B1:B6 is the numbers to ad
 
Top