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
Re: Calulate Hours based on individual daily rates
try changing that part to PRODUCT(Sheet2!$B5,$D$3,Sheet2!$D5)
Re: Calulate Hours based on individual daily rates
Hi crushdrinker06
Nearly there, what I'm trying to is get it to look at the names in Sheet 1 ,column A compare those names against sheet 2, Col B and then if the name in Sheet 1 col A matches multiply the days in sheet 1 col D by the hours/day on sheet 2, col D
Hope that helps.
Kind regards
DezB
Re: Calulate Hours based on individual daily rates
In E3 of Sheet1 put
=IF(ISNA(MATCH(A3,Names,0)),"No Match",PRODUCT(D3,INDEX(Sheet2!D:D,MATCH(Sheet1!A3,Names,0)+4)))I have added the file forum.ozgrid.com/index.php?attachment/69446/
Re: Calulate Hours based on individual daily rates
Hi All.
Wow, excellent, both worked spot, thank you.
Much appreciated and kind regards.
DezB
Re: Calulate Hours based on individual daily rates
You're welcome DezB!
Don’t have an account yet? Register yourself now and be a part of our community!