Notifications
Clear all
Topic starter
I am looking for a custom Excel function The function will need to reference two individual cells and will be checking one of those cells against each cell in an array. It will Count if Cell in array - Cell 1 >0 & < Cell 2. It will also need to know to know where in the array blank cells start and kill the formula there. Ideally it will be a function I can use like this =WithinX(A1,C1, F:F)
Posted : 17/06/2020 1:52 pm
Hi Ramzan
I think i understand what you want to count, but not sure why you need a custom function or why the formula needs to be killed?
I have replicated your data to the right and this formula seems to do what you want -
=--SUMPRODUCT((($N$2:$N$5-I2)>=0)*($N$2:$N$5-I2<=$K$2))
Purfleet
Posted : 18/06/2020 4:18 pm
