Let's see if anyone out there could help me out with this problem... Let's say I was needing to sum up the total in column B.. Easy enough, huh? Well, if it were only that simple (which I am sure it is for most of the people reading this or I wouldn't be here). Let's say the only cells in column B i wanted to add up were cells that contained a specific "Client Code" in column A. Example: | A | B || ABC100 | $500.00 || ZZZ900 | $100.00 || ABC100 | $200.00 || XYZ350 | $ 50.00 |I am needing it to automatically add up all the #s in "B" that has the client code of ABC100. So that would be B1,B3, and to ignore the rest. Is there a formula that would allow me to do this? Thanks in advance!