Thread: DSum criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Emece Emece is offline
external usenet poster
 
Posts: 82
Default DSum criteria

I want to use the DSum function and I have the criteria in different ranges.
In A1:A2 I have one and in G1:G2 the other one. When I want to select them as
the criteria of the function, I try selecting the first range, then press
Ctrl and select the other range. But it doesn't work, Excel keeps telling
ther are too many arguments specified for the function. Which is the correct
way to select different ranges as criteria?

Thanks in advance.

Regards.
Emece.-