VBA Code / Formula for salary per dept

[gnod]

hi,,

how can i compute the total per dept and put it in the User Template without putting the salary of the employee.. pls see my remarks in the attached file..

tnx..

[Jacob Hilderbrand]

You can use SumIf to get the total per department.

=SUMIF(C2:C6,"Finance",D2:D6)

[Zack Barresse]

Cross-posted: http://www.puremis.net/excel/cgi-bin...num=1145210613

Please read: http://www.excelguru.ca/XLKBA/XLKBA05.htm