Not sure if I should be using the COUNTIF formula for the following...
I have a summary worksheet which lists categories A to D, and what I want to find is the number of cells/items on a DIFFERENT worksheet where the criteria are: column D is equal to A and column L is greater than 20%.
Any suggestions???
I have a summary worksheet which lists categories A to D, and what I want to find is the number of cells/items on a DIFFERENT worksheet where the criteria are: column D is equal to A and column L is greater than 20%.
Any suggestions???