dsum to caculate quantity of rows within a range criteria

I have not had too much time with the database formulas, I connect to tables in my databases and perform reports off that... but I imagine DCount will give you the ability to count the same items your doing with DSum

Have you considered using sumif/S() and countif?S() for this instead?

here is a small sample (hope it comed thtough)

TL 1
TL 2
PT 8
PT 29
PT 0
TL 10
TL 11
TL 36
PT 9
AB 50

SUMIF COUNTIF AVERAGEIF
TL 60 5 12
PT 46 4 11.5
AB 50 1 50

OK the last part didnt come through too well, but
60=SUMIF($A$2:$A$11,$A14,$B$2:$B$11)
5=COUNTIF($A$2:$A$11,$A14)
12=AVERAGEIF($A$2:$A$11,$A14,$B$2:$B$11)
all copied down

ok lets try that again...

	A	B	C	D
3	TL	2
4	PT	8
5	PT	29
6	PT	0
7	TL	10
8	TL	11
9	TL	36
10	PT	9
11	AB	50
12
13		SUMIF	COUNTIF	AVERAGEIF
14	TL	60	5	12
15	PT	46	4	11.5
16	AB	50	1	50

B14=SUMIF($A$2:$A$11,$A14,$B$2:$B$11)
C14=COUNTIF($A$2:$A$11,$A14)
D14=AVERAGEIF($A$2:$A$11,$A14,$B$2:$B$11)

That was my initial thought, but I was under the assumption that the D formulas or Database formulas are for data not contained within the sheet. Did a little homework shortly after and I would say that the IF statements are a better choice as you can expand into plural of those (SumIfS, CountIfS, AverageIfS) giving you more to work with should you need it. Glad the DCount worked, but I would agree with FDibbins and suggest checking out the IF based sum,average and counts.

Cheers -