"no function" with calc as data source

When creating a query in design view (in Base):

While using a Calc spreadsheet (or a .dbf file) as the data source I 
can't access functions such as sum etc.  the drop down displays "no 
function" as the only option.

Is this correct or am I doing something wrong?

How else would you sum groups of data in a query.  Should I somehow 
import the Calc data as a table in a Base document - as functions do 
show up there.

Thanks in advance.

gary