| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining formulas | Excel Discussion (Misc queries) | |||
| Help with combining 2 formulas | Excel Discussion (Misc queries) | |||
| combining two formulas | Excel Worksheet Functions | |||
| Combining 2 Formulas | Excel Worksheet Functions | |||
| Combining two formulas | Excel Worksheet Functions | |||
Linear Mode
