I have 3 columns I would like to do an array multiplication formula with an if statement. I have tryed SUMIF and SUMPRODUCT with no luck.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
> </o
>
Column A represents Quantity A5:A5000
<o
> </o
>
Column B represents Criteria B5:B5000
<o
> </o
>
Column C represents Price C5:C5000
<o
> </o
>
I would like the formula to multiply Column A by Column C provided Column B equals (0) zero and return a total of the array.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




Column A represents Quantity A5:A5000
<o


Column B represents Criteria B5:B5000
<o


Column C represents Price C5:C5000
<o


I would like the formula to multiply Column A by Column C provided Column B equals (0) zero and return a total of the array.