Hello All,
I am stuck in a countif logic where i want to execute a formula to the value in a cell first and if the condition is met, add that to the count
For example
Name 1st Entry 2nd Entry
A 100 84
B 100 84
C 100 84
D 100 86
E 100 86
F 100 86
G 100 86
in this, first I want to calculate the percentage of 2nd entry compared to the 1st entry in the same row and if that is above 85%, then take that for counting.
Like this, for the entire column, the total count after applying the formula should be 4
Note: 1st entry wont be 100 always. Just gave that for easiness
Bookmarks