On 11 Oct, 15:06, Doo0592 wrote:
Thanks guys, that worked but I found you only need one - before the
ranges to allow excel to work with the strings else it will return
£0.00 always. Was thinking about ignoring the returned zero values as
well but I can't remember how..

So far I have:

=if(k4=0,"") then sumproduct formula but I can't figure out what goes
inbetween as the "else". I thought it was a comma but it won't accept
it.

NM! I found a handy way to turn off the zero values in the options
menu under view. :)
Thanks again!