"Pete_UK" wrote...
Try this:

=SUM(INDIRECT("WO!J2:J"&ROWS(WO!qry_WO)-1))
....

Or eliminate the volatile INDIRECT call by using

=SUM(WO!J2:INDEX(WO!$J:$J,ROWS(WO!qry_WO)-1))

which has the added benefit that if rows were added above row 2 or columns
inserted or deleted to the left of col J in the WO worksheet, the
nonvolatile formula wouldn't need to be revised.