ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   combining formulas (https://www.excelbanter.com/excel-worksheet-functions/210269-combining-formulas.html)

Rene
combining formulas
 
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:I400100)*('[abc.xlsx]2008
Mine'!G300:I400<=200))+SUMPRODUCT((G2:I40100)*(G2 :I40<=200)))/(COUNT('[abc.xlsx]2008 MIne'!G300:I400)+COUNT(G2:I40))

SUMPRODUCT(--(J11:J40="a"),--(D11:D40<=105),--(D11:D400)/COUNTIF(J11:J40,"a"))

Looking for % in the range of 100-200 in both sheets.

Thanks

Rene
combining formulas
 
Try, try, try...
I solved it...

"Rene" wrote:

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:I400100)*('[abc.xlsx]2008
Mine'!G300:I400<=200))+SUMPRODUCT((G2:I40100)*(G2 :I40<=200)))/(COUNT('[abc.xlsx]2008 MIne'!G300:I400)+COUNT(G2:I40))

SUMPRODUCT(--(J11:J40="a"),--(D11:D40<=105),--(D11:D400)/COUNTIF(J11:J40,"a"))

Looking for % in the range of 100-200 in both sheets.

Thanks


All times are GMT +1. The time now is 04:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com