Good luck!

Along the lines of SumIf, you might find the following of interest.
Hopefully not again telling you something you knew, but I found this to be
very helpful.
http://www.microsoft.com/office/prev...s/column10.asp

hth,

Doug

"rxwillow " wrote in message
...
Thanks everyone that responded. I guess im going to give the SUMIF thing
a try. As far as using the auto filter function; I am familiar with it
and use it daily, but im trying to do away with that. Theres a whole
bunch of other things that my office has to do with these and other
spreadsheets and I think I can streamline the whole process with VBA.
Unfortunately, Im the only person that has had some experience with
programming so this whole project is on me. And since I havent been
programming for almost 3 years now, Ill probably be back here with more
syntax questions.

Thanks everyone.


---
Message posted from http://www.ExcelForum.com/