PDA

View Full Version : VBA Code / Formula for salary per dept



gnod
04-16-2006, 11:16 AM
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
04-16-2006, 12:16 PM
You can use SumIf to get the total per department.


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

Zack Barresse
04-16-2006, 12:28 PM
Cross-posted: http://www.puremis.net/excel/cgi-bin/yabb/YaBB.pl?num=1145210613

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