Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custum Cell Format - display 0 (zero) when cell is empty | New Users to Excel | |||
find last cell in range with data, display cell address | Excel Worksheet Functions | |||
display text in one cell as a number in an adjacent cell in excel | New Users to Excel | |||
Display contents of cell in another cell as part of text string? | New Users to Excel | |||
How to click on a cell and have the content of the cell display in a different cell | Excel Worksheet Functions |