Posted to microsoft.public.excel.worksheet.functions

Michael Dam Michael Dam is offline

external usenet poster

Posts: 1

DSUM with variable Criteria

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DSUM criteria	Edward	Excel Worksheet Functions	3	July 9th 07 04:19 PM
DSum criteria	Troubled	Excel Worksheet Functions	2	November 8th 06 04:22 AM
HOW TO USE DSUM WITH MORE THAN ONE CRITERIA	Michael H.M.Mikhail	New Users to Excel	1	May 23rd 06 09:42 AM
Using DSUM with several criteria	matthoffman33	Excel Worksheet Functions	2	May 6th 06 05:46 PM
conditional criteria in DSUM	S. H. Drew	Excel Discussion (Misc queries)	7	May 2nd 05 06:14 PM

All times are GMT +1. The time now is 11:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us