Need help with sum function!

  • Thread starter Thread starter nrage21
  • Start date Start date
N

nrage21

I have a workbook with 2 sheets...
Sheet1 is a long list of info, column G has employee codes (i.e. JV
VM, etc), column M has numbers (i.e. 2, 3, 1, 7, etc)

What I need to do, is place a function in Sheet2 column B that wil
look for any instance of an 'employee code', take the values in colum
M that corresponds to it and sum it all up and place the result i
Sheet2 column B.

I know this is easy, but I suck with worksheet functions. Please help.

- Larry -
VBA Amateu
 
Thanks Frank!

Reading I was able to made the following... it seems to work!

=SUMPRODUCT((Sheet1!$G$2:$G$10314="WM")*(Sheet1!$M$2:$M$10314))


I think you helped me with something like this before... thx
million!

- Larry -
VBA Amateu
 
Back
Top