Hello,

I need to sum info that meets more than one criteria. Excel has Data Base
funtions that work by referencig to a range that contain criteria to be used
as filters for data. In the help of dsum() it says you can use criteria
resulting from a formula instead of using ranges, i've been trying to apply
that and nothing.

Example

A1 Test
A2 1
A3 2
A4 3
A5
A6 =A2average($A$2:$A$4)

Using range:
dsum(A1:A4,A1,A1:A2) result=1

Using formula, (as I understand the help file):
dsum(A2:A4,,A6) expected result=3, worksheet result=#¡Value!




The help file says i can use: =a2average($a$2:$a$3) as long as i use
relative reference for a2 and absolut for tha range a2:a3 and whe tha formula
returns boolean.