Can some one please help me figure out the proper formula I should be using.
Currently im using =COUNT(INDIRECT("K4:N4"))
This tells me how many of the boxes have a value in them in the four cells K4:N4... Im wanting to use indirect because as the value in say K4 expire, my users would then highlight L4:M4 and drag them left to the cell in column K. Without using indirect, the formula will change my reference field from K4:N4.....
So the problem comes in when I want to drag this formula down and have the K4:N4 update to K5:N5 and so forth.
Im also having the issue with this formula as well. Wanting both K3's to update to K4 and so forth.
=IF(ISBLANK(INDIRECT("K3")),"",(INDIRECT("K3")+365))
Im thinking i should use Row but cannot figure out how to implement.
Currently im using =COUNT(INDIRECT("K4:N4"))
This tells me how many of the boxes have a value in them in the four cells K4:N4... Im wanting to use indirect because as the value in say K4 expire, my users would then highlight L4:M4 and drag them left to the cell in column K. Without using indirect, the formula will change my reference field from K4:N4.....
So the problem comes in when I want to drag this formula down and have the K4:N4 update to K5:N5 and so forth.
Im also having the issue with this formula as well. Wanting both K3's to update to K4 and so forth.
=IF(ISBLANK(INDIRECT("K3")),"",(INDIRECT("K3")+365))
Im thinking i should use Row but cannot figure out how to implement.