sumproduct with indirect value

[lpvdsteen]

I have two sheets like below, what I would like is an excel sumproduct-like formula which multiplies the ( time with the registry (the one under the name) and the factor on the second sheet corresponding with the frequency (=1/days) ) *7
for example: for Albert: 60*0*0,047619+60*0*0.02381+60*0*0.032258+30*1*0.1428+60*1*0.01087+60*1*0.142857+60*0*0.016393 *7 = 94.56522 ~ 95 min
using the sumproduct of course we can multiply the various columns on the firstsheet. I could add a column for the factor but this creates another problem in conformity and compatibility

I would need in the total cells is something like this, but of course the vlookup wouldn't work.

SUMPRODUCT($B2:$B8 , $C1:$C8 , VLOOKUP($A1:$A8 , frequencysheet!A$1:C$10 , 3 , 0)) *7

Hope it is clear. I translated from Dutch so pardon the punctuation which is different in the Dutch version

basesheet

frequencysheet

 

[HongRu]

for example: for Albert: 60*0*0,047619+60*0*0.02381+60*0*0.032258+30*1*0.1428+60*1*0.01087+60*1*0.142857+60*0*0.016393 *7 = 94.56522 ~ 95 min

I am not sure what do you want ?
How about this ?
for Albert:
(60*0*0.047619+60*0*0.02381+60*0*0.032258+30*1*0.1428+60*1*0.01087+60*1*0.142857+60*0*0.016393)*7
=94.56522

 

[HongRu]

why not try to sort the first column of the basesheet just the same as the first column of the frequencysheet？
It will be much easier.

 

[lpvdsteen]

And thanx to the similar threads which I didn't find in the search, I have the answer, I also didn't think in that direction; Sum.If.
=SUMPRODUCT($B2:$B8 , $C1:$C8 , SUM.IF(frequencysheet!$A$1:$A$10 , $A1:$A8 , frequencysheet!$C$1:$C$10)) *7

 

[lpvdsteen]

why not try to sort the first column of the basesheet just the same as the first column of the frequencysheet？
It will be much easier.

Sorting is not an option nor of additional value as there kan be many morge rows. The idea was that the factoring for an identifiing column on anonthe sheet can be used in an array formule.
maybe te calculation example was too confusing and ik shouldn't have put that in. it explained coming to 95 mins instead of 94.
anyway, using the sum.if option made it work.