SUM OF A RANGE

D

Dave

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
 
J

Jacob Skaria

Dear Dave

Try the below

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

If this post helps click Yes
 
E

Eduardo

Hi Dave,
try

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

Dave

Thats excellent! Im sure Ive tried it. The one thing you have to be carefull
with is the formulas and filtering in the sheet your reading from. If you
keep these in or move anything the formula doesnt work.

But this is good! Thanks

Jacob Skaria said:
Dear Dave

Try the below

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

If this post helps click Yes
---------------
Jacob Skaria


Dave said:
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
Click to expand...
Click to expand...
 
J

Jacob Skaria

Thanks for the feedback...
--
If this post helps click Yes
---------------
Jacob Skaria


Dave said:
Thats excellent! Im sure Ive tried it. The one thing you have to be carefull
with is the formulas and filtering in the sheet your reading from. If you
keep these in or move anything the formula doesnt work.

But this is good! Thanks

Jacob Skaria said:
Dear Dave

Try the below

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

If this post helps click Yes
---------------
Jacob Skaria


Dave said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top