almost DSUM, but is there another database - criteria funcion?
Have you tried Sumif()
sumif(b1:b100,"=A",c1:c100)
Lance
-----Original Message-----
I have a problem with excel.
I have a list of expenses, sorted by date. The expenses
have a code, so some
expense are coded "A", others "B" and so on; I have 10
codes. It is
something like this: "Date - Code - Amount Spent".
I need to have subotals of the expenses, as per codes.
All the "A" expenses,
all the "B" expenses, and so on.
I know the formula *DSUM(database,filed,criteria)* but
the criteria works
only for adjoining cells with the "Label" on top. If I
have my list of
codes, I should make a title line (label) and
underneath "A", then another
label line and underneath "B" and so on.
I believe there must be another way for calculating
subtitels like this.
The subtitle function is not right as well since it
doesn't group my
expenses for non adjoining cells.
Can anyone help me?
Thanks in advance.
PS: I am using Excel 2002 under win XP home edition.
.
|