Data Base Functions


G

Gerardo

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 =A2>average($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: =a2>average($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.
 
Ad

Advertisements

Ad

Advertisements

G

Gerardo

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top