# Calulate Hours based on individual daily rates

• 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

forum.ozgrid.com/index.php?attachment/69435/

## Files

• 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

Code
``=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/

## Files

• Re: Calulate Hours based on individual daily rates

Try this.....

In E3

Code
``=IFERROR(VLOOKUP(A3,Sheet2!\$B\$4:\$D\$8,3,0)*D3,"")``

and copy down.

Regards.
sktneer

• Re: Calulate Hours based on individual daily rates

Hi All.

Wow, excellent, both worked spot, thank you.

Much appreciated and kind regards.

DezB

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!