Excel: Using DSUM, I need to evaluate 2 criteria that are not toge

G

Guest

The CRITERIA field in DSUM looks for adjacent columns in a table. If a column
or cell is blank, it does nothing.

How can I use A1:A2 and, say, C1:C2 as the criteria?
 
P

Peo Sjoblom

Not possible, the criteria range needs adjacent cells, is there any
particular problem involved by
not using it this way?


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Know enough to get myself in too deep" <Know enough to get myself in too
(e-mail address removed)> wrote in message
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DSUM criteria 3
Summing a range of cells with criteria 7
Data Base Functions 2
Concatenating Criteria in DSUM 2
DSUM with criteria:blank OR > some value 2
Excel 2007: =DSUM not working as expected 4
DSUM - Modifying the function... 1
DSUM - non contiguous criteria range 9

Top