View Single Post
  #1   Report Post  
Danny J
 
Posts: n/a
Default ok more on sumproduct

Hi all,

OK I have the sumproduct working well, which is great....but how do I set it
up so that if the result is going to be 0 the cell appears blank....I have
bashed my brains with IF statements (the way I normally do this) but I don't
think it will work.

Any ideas?

Danny