Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif and then regular equation to non selected cells
Ok I have half of this equation working, and I'm hoping someone can help me
finish it off. =SUMIF(W3:W10,"x",Q3:Q10) (***This works***) if Q3 (for exmple) does not have an "x" i want to multiply W3 and H3 and add that total to the above equation. Column H = Pieces Column W= Weight Column Q= determines if Column W is gross or net weight. This seems like it should be simple, I just can't tell what I'm missing. |