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
wrote in message
...
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?