kkj
03-14-2012, 09:46 PM
Hi guys, I want to calculate the total number of entries based on some condition (values greater than 0.2) from A1 to G1. And want to display the result at K1. The value (0.2) works as threshold and will be provided from another worksheet say sheet2 (cell A1).
I have written this formula
=COUNTIF(A1:G1,">=0.2")
But it takes input from Sheet1 (K1).
I want it to take input from sheet2(A1) and calculate in sheet1(K1)
Regards,
I have written this formula
=COUNTIF(A1:G1,">=0.2")
But it takes input from Sheet1 (K1).
I want it to take input from sheet2(A1) and calculate in sheet1(K1)
Regards,