Thread: Bradford factor work sheet

Hello,

I'm trying to put together a worksheet that will calculate the bradford factor.
I'm stuck on something that I'm sure is probably very simple....but not for me.

I've attached a small sketch with what i've got so far and more detail as to what i need help with.

Your help with this would be very much appreciated.
Thanks in advance

James.

For you example

sumproduct((b10:b13>b3)*1) 

sumproduct((b10:b13>b3)*(c10:c13))

Is that what you require?

Regards

Dav

Hello,

Thanks for your responce, I've tryed the above some sums but can't seem to get them to work.
I've tryed entering them normaly and as an array but they just return zero?


Thanks
James

try,

=SUMPRODUCT(($B$10:$B$13>$B$2)*($C$10:$C$13))

i have changed the attached file as well

cheers reg

Works a treat thank you.

kegards
James.