Here's my current formula:

=SUMIF(A3:A50,"Consumer",J3:J50)/C55

This works fine to get an average sum for everything that reads Consumer,
but now I need to sum only the positive $ amounts in column "J3:J50". How and
where do I insert this extra condition?

Any help would be appreciate. Thanks

Hi,
Try

=sumproduct(--(a3:a50="Consumer"),--(J3:J500),J3:j50/c55)

If this helped please click yes, thanks

"lightstation67" wrote:

Here's my current formula:

=SUMIF(A3:A50,"Consumer",J3:J50)/C55

This works fine to get an average sum for everything that reads Consumer,
but now I need to sum only the positive $ amounts in column "J3:J50". How and
where do I insert this extra condition?

Any help would be appreciate. Thanks

=SUMProduct(--(A3:A50="Consumer"),--(J3:J500),J3:J50)/C55


"lightstation67" wrote:

Here's my current formula:

=SUMIF(A3:A50,"Consumer",J3:J50)/C55

This works fine to get an average sum for everything that reads Consumer,
but now I need to sum only the positive $ amounts in column "J3:J50". How and
where do I insert this extra condition?

Any help would be appreciate. Thanks

=SUMPRODUCT(--(A3:A50="Consumer"),--(J3:J500),--(J3:J50))/C55
--
If this post helps click Yes
---------------
Jacob Skaria


"lightstation67" wrote:

Here's my current formula:

=SUMIF(A3:A50,"Consumer",J3:J50)/C55

This works fine to get an average sum for everything that reads Consumer,
but now I need to sum only the positive $ amounts in column "J3:J50". How and
where do I insert this extra condition?

Any help would be appreciate. Thanks

Now, what if I need to sum only the amounts in column "J3:J50" where there
is no "#Value" displayed.


"Jacob Skaria" wrote:

=SUMPRODUCT(--(A3:A50="Consumer"),--(J3:J500),--(J3:J50))/C55
--
Here's my current formula:

=SUMIF(A3:A50,"Consumer",J3:J50)/C55

This works fine to get an average sum for everything that reads Consumer,
but now I need to sum only the positive $ amounts in column "J3:J50". How and
where do I insert this extra condition?

Fix the cells which are displaying #Value. Typically done with:
=if(iserror(yourcalculation),0,yourcalculation)

Regards,
Fred

"JEB" wrote in message
...

Now, what if I need to sum only the amounts in column "J3:J50" where there
is no "#Value" displayed.


"Jacob Skaria" wrote:

=SUMPRODUCT(--(A3:A50="Consumer"),--(J3:J500),--(J3:J50))/C55
--
Here's my current formula:

=SUMIF(A3:A50,"Consumer",J3:J50)/C55

This works fine to get an average sum for everything that reads
Consumer,
but now I need to sum only the positive $ amounts in column "J3:J50".
How and
where do I insert this extra condition?