Need help with sum function!

[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

 

[Frank Kabel]

Hi
try for example
=SUMIF('sheet1'!$A$1:$A$1000,"JV",$B$1:$B$1000)

you may also have a look at pivot tables:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html

 

[nrage21]

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