Thank you. That worked perfectly.
"Max" wrote:
"michelle" wrote:
The thing is, I need a formula that looks at everything in the columns, not
just the cell in that row. Is this even possible?
Perhaps you mean something like this, placed in D1:
=SUMIF(B:B,C1,A:A)
Formula can be copied down
to return correspondingly for other values in col C
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---