Hi Domenic,

Great! Thank you so much.

Domenic wrote:
Try...

=IF($A2<B$1,SUM(--(MMULT(--(Results=$A2),TRANSPOSE(COLUMN(Results)^0))*M
MULT(--(Results=B$1),TRANSPOSE(COLUMN(Results)^0))0)),0)

...confirmed with CONTROL+SHIFT+ENTER.

Cheers,
Sam

Domenic wrote:
Try...

=IF($A2<B$1,SUM(--(MMULT(--(Results=$A2),TRANSPOSE(COLUMN(Results)^0))*M
MULT(--(Results=B$1),TRANSPOSE(COLUMN(Results)^0))0)),0)

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

Hi Domenic,

[quoted text clipped - 48 lines]
Thanks
Sam


--
Message posted via http://www.officekb.com