Why don't you share some specific information about the various ranges
involved instead of all these abstract statements. You'd be surprised at
how much can be done in XL w/o using VBA. Too many rely on the latter
prematurely.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article .com,
says...
Yes, I tried...the SUMIF is the issue...the data entry is dependent
upon two different ranges so the validation isnt working. I was
thinking I needed to use VBA.