View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
puiuluipui puiuluipui is offline
external usenet poster
 
Posts: 468
Default 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!