Formula Help?

[brin]

I am using the following formula to capture all data where the number of days is less than 21 days, this works great . What i would like to do is work out the average so i need to count the values of the numbers captured i.e

=Abs(Sum([mo to com]<=21))

55
14
78
17
66
3
11
21
7
20
12

Number of days less than 21 days = 8 ([mo to com] (being my field).
I need a total of those values but to ignore the ther data greater than 21 days.

Please help.

 

[jtvcs]

Although you placed this question in the Reports area, my recommendation would be to do a summation query to get the result you want. If you need this answer on a report, then create a subreport on your main report to show the query's results.

In a query use the field tat has the numbers, click on the Totals button (looks like a funny 'e') on the toolbar in the query design window, then in the grid row Totals, select Sum, set your criteria to <21 and the answer when you run the query will be your 'Sum' of the values that you want.

Good luck.