Been racking my brains all day on this, I'm sure one of you clever
people out there can help me. I need to do a simple calculation based
on hourly rates, example as follows.
TA bills out at $20 an hour
MF bills out at $50 an hour
FG bills out at $70 an hour
All the above are in the same column of a worksheet....how the hell do
I get a total for the above as a grand total. i.e. IF A1 = TA, do a
calculation, add to total. IF A6 = MF do a calculation add to total and
so on. The initials are in drop down boxes....and the input needs to be
simple cos numptys like me have to do this... :)
Any help would be very appreciated.
Chris
AKA Excel virgin
--
csandi
------------------------------------------------------------------------
csandi's Profile:
http://www.excelforum.com/member.php...o&userid=28809
View this thread:
http://www.excelforum.com/showthread...hreadid=484973