Calculating Total Pay For Multiple Employees

Hi Sue,

In C50 copied down...

=SUMIF($B$5:$B$45,B50,$K$5:$K$45)

Note: Try not to ever use merged cells if you can avoid it...instead use centeracross selection.

http://thenewpaperclip.com/2008/04/1...in-excel-2007/