Place this formula in your desired cell, adjust the listed ranges to
meet your needs:

=SUMIF(B2:B100,"=Groceries",D2:D100) where B2:B100 is your Category
column and contains "Groceries" and D2:D100 is your amount column.

Good Luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=476825