I found the answer from another post, but I'm sure I'll have more
questions. Thank for those who looked. If you have anymore suggestions
let me know, Thank you

the correct formula was:
=SUMIF(Demographics!$F$2:$F$212,$A2,Demographics!$ O$2:$O$212)

I do have another question actually. In the Total Sales worksheet, I
have a a cell in S2 that I wish to show the max value from the "total
sales" colum and then show the first and last name related to that
particular row where the max value was. so, I only have =MAX(O2:O112),
but I want to show the Name associated with the max and not just the $
amount.


--
dutch4fire23
------------------------------------------------------------------------
dutch4fire23's Profile: http://www.excelforum.com/member.php...o&userid=36900
View this thread: http://www.excelforum.com/showthread...hreadid=566146