Hi,

I'm stuck with the following problem:

Turning this formula:

{=AVERAGE(IF($M$2:$M$10000>='hele utvalget'!$T$4;(DAYS360('hele
utvalget'!$T$4;($M$2:$M$10000))/360)))}

Into a conditional sumproduct formula where the above expression are to be weighted with a second row, fex. f2:f10000

ie. something like this:

{=SUMPRODUCT(IF($M$2:$M$10000>='hele utvalget'!$T$4;(DAYS360('hele utvalget'!$T$4;($M$2:$M$10000))/360));(F2:10000))/SUM(F2:10000)}

My problem is to have the correct cells picked out in the "F-list", rather than weighting the whole list.

I would greatly appreciate any help you can give!

Thanks
Christian