View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default DSUM with variable Criteria

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