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.

Hi

The SUMIF formula is suited for that. Check helpfiles please.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"h99miller" wrote:

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.

Thanks,

just created the formula I was looking for with your direction. I love Excel
but have not used it since early 2000.

"Wigi" wrote:

Hi

The SUMIF formula is suited for that. Check helpfiles please.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"h99miller" wrote:

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.