This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 1%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJE%3C/text%3E%3C/svg%3E)
Hello. I was able to get help from this community several years ago in developing the formulas in the attached. Unfortunately, something is not allowing (at least some of) the formulas in cells L4:L15 to work correctly now. I know for a fact that the formula in L4 (selected in the attached picture) should be returning something other than FT3 since I can eyeball the data to the left and see that there are more than two rows meeting the criteria in the formula. It also makes me concerned that the data in the same cell ranges in columns M, N, and/or O may not be correct as well. By the way, there are 144 rows of data in columns E-I. Thank you all for any assistance you can provide in helping me get these formulas working correctly again! Screenshot 2024-04-26 151258.jpg
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
The cells in column E contain text, not numbers. You can tell because the values are left aligned, not right like the numbers in column F.
Replace the 3 in the formula with "3", including the quotes, and see if that fixes the problem.