My standard approach to such a problem is to place the raw "grocery"
data in another part of the worksheet (or maybe another worksheet in
the same workbook). Then the "grocery" cell can become =sum(aa1:aa10)
where aa1:aa10 is the range where you put the raw grocery data.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=396812