Hi,

I've figured out what was wrong with this; the range from which I was trying to multiply included blank cells. When I filled any blank cells with a "1" (which obviously won't affect the result of multplication), the formula works as expected.

Thanks