I am trying to track some expenses and want to create a formula that will
capture the amounts next to same text. For instance if column b = food then
sum amounts in column c. I know I can sort by column and group all together
then sum but that does not fit the format I want to create. Any help on how
to create this formula in Excel 2007 would be very much appreciated.