Hello all,
I have a spreadsheet that I am trying to create a number of formulas on:
The spreadsheet contains columns of data, columns D, F, I, and L and within these columns are %'s.
For each row (eg:2) - I want to count the instances that D2, F2, I2 and L2 are greater than 3%. The count if function works great when the Columns between are deleted - but cant figure out a way to look at seperate cells and count on each?
eg: I am trying to do: =Countif(D2,F2,I2,L2,">3%") but doesn't work as its expecting the criteria once the comma is entered. Is there any way to do this as I need to flag up when more than 2 instances occur.
Any ideas appreciated.
Thanks
Bookmarks