Hi Dave,
try

=SUMPRODUCT(--([Query.xls]CLIENTS!F2:F8513="Yes"),--([Query.xls]CLIENTS!D2:D8513<30000),"),--([Query.xls]CLIENTS!D2:D8513))


"Dave" wrote:

Hi,

I HAVE USED THE FOLLOWING FORMULA TO COUNT THE NUMBER OF TIMES A VALUE
APPEARS BELOW 30000:

=SUMPRODUCT(--([Query.xls]CLIENTS!F2:F8513="Yes"),--([Query.xls]CLIENTS!D2:D8513<30000))

HOWEVER, I WOULD LIKE TO CALCULATE THE SUM OF THOSE VALUES BELOW 30000.

CAN ANYONE HELP WITH THIS?

THANKS