Thread
:
DSUM with variable Criteria
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
external usenet poster
Posts: 10,593
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
Reply With Quote
Bob Phillips
View Public Profile
Find all posts by Bob Phillips