ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   if, then display next cell (https://www.excelbanter.com/excel-discussion-misc-queries/244133-if-then-display-next-cell.html)

puiuluipui

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