what is the syntax to define an array that is not contiguous cells?
B Bob Phillips Oct 17, 2003 #2 Ray, An example with SUM =SUM(A1:A3,A6:A8) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Ray, An example with SUM =SUM(A1:A3,A6:A8) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
