Hi,
I have the below formula which is working good.
=IFERROR(SUMPRODUCT(COUNTIFS('Raw Data'!$P$2:$P$20000,$A2,'Raw Data'!$X$2:$X$20000,">=6",'Raw Data'!$A$2:$A$20000,Input!$B$2,'Raw Data'!$E$2:$E$20000,Rough!L$1:$L$11,'Raw Data'!$G$2:$G$20000,Input!$C$2))/SUMPRODUCT(COUNTIFS('Raw Data'!$P$2:$P$20000,$A2,'Raw Data'!$X$2:$X$20000,">=0",'Raw Data'!$A$2:$A$20000,Input!$B$2,'Raw Data'!$E$2:$E$20000,Rough!L$1:$L$11,'Raw Data'!$G$2:$G$20000,Input!$C$2))," ")
Now my problem is, if I select "Overall" in sheet input which is in cell B2 it should calculate (US&C,EAMER and GAR). Actually these are the different conditions for which it is working fine individually.
Ex: If I select US&C in B2 it is giving the result and if EAMER is selected then it is calculating the required result and giving the output.
Sameway for GAR also it is working.
So, if i select Overall then it should calculate all (US&C+EAMER+GAR)..
Help please!!
If I select Overall in input sheet, then what changes i have to make in the above formula. I am attaching the sample file for reference. The formulas are there in sheet WCSAT from B2 to C33. Please help...
Bookmarks