If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|