This sounds like a great time to read up on VLOOKUP() [or even HLOOKUP()] and
also perhaps SUMIF().

"Mark" wrote:

I want to enter a data item in my spreadsheet and have the entry filtered by
catagory to another range for summing (the summing can be a separate step.
For example, entering a expense item where the entry goes in to a range with
other data nd the entry is also placed in another range defined by category.
thanks