Hi,

Am Fri, 28 Nov 2014 06:25:38 -0800 (PST) schrieb Jonathan Pence:

Do I need to specify the range in the "-"? ex) $B$18:$B$35<"$G$144:$G$147"

no, if you don't have any value from G144:G147 in column B you have a
hyphen into the cell. So you only have to calculate with the cells that
don't have a "-"to have all values


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional