I am trying to sum values in a column on a worksheet, using criteria in two
other columns on the same worksheet, which are defined by one absolute and
one relative reference on a second worksheet. The wizard works when I use two
simple criteria, such as "sam" and "1.5", but does not work when I try to use
criteria located in cells on the second worksheet, such as "$E$2" and "f4" --
ronb