Hi Folks
I'm trying to get a formula to look at a range of names, look up a name in another range and then calculate the hours used based on the number of days x a their daily rate.
I've come uo with this: SUMIF($A$3:$A$10,Sheet2!$B5,$D$3*Sheet2!$D5) but the * seems to be throwing it. Can anyone tell me what i'm doing wrong please?
I've attached a sample if that helps.
Kind regards
DezB