My earlier guess on your scenario was incorrect

From your clarification in the other branch:
=SUMIF(cat_col,$A157,debit_col)

To edit the 2 defined ranges: cat_col & debit_col,
just click Insert Name Define (options are there)
Select say: cat_col in the dialog box,
then you can edit the "Refers to" part of it (eg extend the range)
Click Add, then repeat for debit_col
Click OK when done
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---
"Jennifer C." wrote:
Thanks Max, unless I did it wrong it didn't work. I'm trying to select ALL
of Column C but even when I try to do that or just select the column it
doesn't work. :(