R
Rene
Hello. I'm trying to combine the two formulas into one. I can break the
formulas into seperate parts; then calculate, but that adds 150+ cells.
SUMPRODUCT(('[abc.xlsx]2008 Mine'!G300:I400>100)*('[abc.xlsx]2008
Mine'!G300:I400<=200))+SUMPRODUCT((G2:I40>100)*(G2:I40<=200)))/(COUNT('[abc.xlsx]2008 MIne'!G300:I400)+COUNT(G2:I40))
SUMPRODUCT(--(J11:J40="a"),--(D1140<=105),--(D1140>0)/COUNTIF(J11:J40,"a"))
Looking for % in the range of 100-200 in both sheets.
Thanks
formulas into seperate parts; then calculate, but that adds 150+ cells.
SUMPRODUCT(('[abc.xlsx]2008 Mine'!G300:I400>100)*('[abc.xlsx]2008
Mine'!G300:I400<=200))+SUMPRODUCT((G2:I40>100)*(G2:I40<=200)))/(COUNT('[abc.xlsx]2008 MIne'!G300:I400)+COUNT(G2:I40))
SUMPRODUCT(--(J11:J40="a"),--(D1140<=105),--(D1140>0)/COUNTIF(J11:J40,"a"))
Looking for % in the range of 100-200 in both sheets.
Thanks