SUM PRODUCT – Multiple Critera Failing at Last Arguement
Good Morning,
I am having trouble with the following formula. It seems to bee faling at the * HX!BC1:BC63590 criteria. I could really use help with this. I am also attaching a small data set. Thanks,
=SUM(SUMPRODUCT(HX!DV1:DV63590 = 18)*
(HX!Q1:Q63590 = “0735”)*((HX!P1:P63590 = 94001) + (HX!P1:P63590 = 91142) + (HX!P1:P63590 = 94004))*((HX!EN1:EN63590 = “5500”) + (HX!EO1:EO63590 = “5500”) + (HX!EP1:EP63590 = “5500”) + (HX!EQ1:EQ63590 = “5500”)) *
HX!BC1:BC63590 ))
Good Morning, I am having trouble with the following formula. It seems to bee faling at the * HX!BC1:BC63590 criteria. I could really use help with this. I am also attaching a small data set. Thanks, =SUM(SUMPRODUCT(HX!DV1:DV63590 = 18)*(HX!Q1:Q63590 = “0735”)*((HX!P1:P63590 = 94001) + (HX!P1:P63590 = 91142) + (HX!P1:P63590 = 94004))*((HX!EN1:EN63590 = “5500”) + (HX!EO1:EO63590 = “5500”) + (HX!EP1:EP63590 = “5500”) + (HX!EQ1:EQ63590 = “5500”)) *HX!BC1:BC63590 )) Read More
