In article m,
Wizard of Draws wrote:
I also wanted to comment that, for my version of Excel at least, it was
required for me to rename the cell that contained the cutoff formula. For
some reason, just referencing the default cell name made the formula not
work.

When you copy formula cells in Excel the default is to treat the other
cells referenced as relative, so that if you make 'B1' reference 'A1'
and then copy it to 'B2' it will reference 'A2'. To stop that you can
either name the cell or use $A$1 (the $ for each of the row and column
nails them down).

I suggested renaming because it even works across sheets (in case you
wanted the summary on a separate sheet) and the syntax for referring
to values in other sheets is ugly.

--
Ben Jackson

http://www.ben.com/