Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
It doesn't seem so, but why would you need to, cells gives you full
flexibility. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Michael Dam" <Michael wrote in message ... I'm trying to let my DSUM-formula run along an accountsheet. Need to have a possibility to let criteria be variable: Amount Account 100 100 50 200 25 300 =DSUM(Q12:R15;"Amount";Q21:Q22) Criteria Result Account 25 300 Above is working, but; =DSUM(Q12:R15;"Amount";"Account"&300) Is this in any way possible?? Thks Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DSUM criteria | Excel Worksheet Functions | |||
DSum criteria | Excel Worksheet Functions | |||
HOW TO USE DSUM WITH MORE THAN ONE CRITERIA | New Users to Excel | |||
Using DSUM with several criteria | Excel Worksheet Functions | |||
conditional criteria in DSUM | Excel Discussion (Misc queries) |