Add data by dates.

[pathfinder2000]

How do I sum the numbers in a column for dates within specific months for certain codes. For example.. from a list of bills, I want to sun the total for food for that month and a separate sum for money spent for fuel, etc. I have column for date, code for item F=food, L for , etc.. and a column for amount.

I am using a Mac Air El Capitan, Excel 2011.

Appreciate your assistance.

[guru008]

Category Amount
F 20
F 10
F 10
L 20
L 30
L 40

Try this formula : =SUMIF($A$9:$A$14,A9,B9:B14)
if you have more than one criteria i.e. month and category

Use =sumifs(rangeSum, Range1, Criteria1, Range2, Criteria2)