Formula help

  • Thread starter Thread starter Judd Taylor
  • Start date Start date
J

Judd Taylor

I would like to request some help with a formula I can't
quite figure out, but I think I'm close.

I have a list of data. I want a sum of numbers in
column "I" if column "A" = 01/01/04.

Basically, I'm trying to add numbers on a budget report,
to get a monthly total. So where column A has the month,
I want to add all numbers in column I in that month. The
list of data is sorted alphabetically by title, not
sorted by month.

I've been trying function/lookup & reference/vlookup and
database/DSUM, and I think I'm close, but I can't get it
to work correctly.

Thanks for any formula suggestions.
 
Hi
not sure if you want to sum the numbers for a day or a month but try
either (assumption: column B stores the values to sum):
1. for a specific day:
=SUMPRODUCT(--(A1:A1000=DATE(2004,1,1)),B1:B1000)

2. For a month (e.g. January 2004)
=SUMPRODUCT(--(MONTH(A1:A1000)=1),--(YEAR(A1:A1000)=2004),B1:B1000)

you may also take a look at pivot tables for these kind of reports:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
 
Back
Top