Forum Discussion
How to link cells as criteria for CountIF function
Briefly, I have 314 lines of data with each line containing ~30 data points. For my purposes I want to identify any data points within each line that are considered "Hits" by whether or not they a...
In stead of typing ">2.99" use ">"&F2
Now you can copy the formula across columns. F2 will become G2, H2 etc. when copied towards the right. And E2, D2 etc. when copied to the left.