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.
| 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!
Edited by kbdavis, 05 August 2013 - 11:12 PM.