SUMIF w/multiple conditions
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?
|