R
Rhiannons_Wish
I've been reading some of the postings and trying to create a formula that
adds from one column based on multiple criteria:
=SUMPRODUCT(--('BOM LIST'!$J$8:$J$770=B31),--('BOM
LIST'!$A$8:$A$770={"S","S-FED","O"}),--('BOM
LIST'!$G$8:$G$770={"F","Q","R"}),'BOM LIST'!$Z$8:$Z$770)
What am I doing wrong?
Also, can anyone reccommend a book on how to increase my knowledge of such
formulas?
adds from one column based on multiple criteria:
=SUMPRODUCT(--('BOM LIST'!$J$8:$J$770=B31),--('BOM
LIST'!$A$8:$A$770={"S","S-FED","O"}),--('BOM
LIST'!$G$8:$G$770={"F","Q","R"}),'BOM LIST'!$Z$8:$Z$770)
What am I doing wrong?
Also, can anyone reccommend a book on how to increase my knowledge of such
formulas?