Solution - sorry for the delay
Hello EESDL,
I have been away and could not respond sooner, I suggest:
Assuming:
Cells B2:H2 contain titles: Code, Date, Rate1, Rate2, Rate3, Rate4, Rate5.
Cells B3:B25 contain jobcodes
Cells C3:C25 contain Dates
Cells D3:D25 contain Hours Rate1
Cells E3:E25 contain Hours Rate2
Cells F3:F25 contain Hours Rate3
Cells G3:G25 contain Hours Rate4
Cells H3:H25 contain Hours Rate5
In Cells K2:P2 enter: Code, Rate1, Rate2, Rate3, Rate4, Rate5.
In Cells K3:K10 enter the codes: Charter, Personal, Business1, Business2, Business3, Business4, Business5, Business6.
Then in Cells L3:P10 enter the formula =SUMPRODUCT(($B$3:$B$25=$K3)*($D$2:$H$2=L$2)*$D$3:$H$25)
Obviously when you go past row 25 you have to extend the formula ranges: $B$3:$B$25 and $D$3:$D$25.
I would echo Genghis' point that for a business application there needs to be some form of error checking calculation.
Hope this helps
EG