![]() |
if, then display next cell
Hi, i have this code:
=IF(SUMIF(A1:L1,TEXT(TODAY(),"mmm"),A2:L2)=0,"No Entry",SUMIF(A1:L1,TEXT(TODAY(),"mmm"),A2:L2)) I need this code to be modified to display next cell; Ex: -this is what code is doing now- The code is in C8 and extract 125 A1=september B1=125 This is what i need: The code is in C8 and extract 425 A1=september B1=125 B2=425 Can the code display the cell next to the one is displayed now? (cell+1 or something, but without specify the cell) Can this be done? Thanks! |
All times are GMT +1. The time now is 12:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com