Data Base Functions
 

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.

Data Base Functions
 

Hi Gerardo
Try
=dsum(A1:A4,A1,A5:A6)

Regards,
Pedro J.

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.

Data Base Functions
 

thank you Pedro, It worked fine.
I need two or more criteria to extract the right text from a data base. If
you use vlookup you can work with one criteria/field only, . The problem I
have with selecting ranges, it seems to be the same when using formula since
i need the extra row. Can I use the formula inside the data base function in
a way that those criteria vary with each row?

"Infinitogool" wrote:

Hi Gerardo
Try
=dsum(A1:A4,A1,A5:A6)

Regards,
Pedro J.

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.