if, then display next cell

P

puiuluipui

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!
 
J

John Bundy

You are either incorrect about how the data is displayed, or about the
results. First you say A1=september
your formula will never find that because it is looking for sep
If B1=125, you do not get this result by putting the given formula in C8.
The formula you have does this:
For each column A-L that contains sep in row 1, sum what is in that column
in row 2
| A | B | C | D |
1 sep 125 oct sep
2 100 425 55 10

the result you will get in C8 is 110 because A1 contains sep, and A2
contains 100 + D1 contains sep, and D2 contains 10.

It doesn't sound like this was your intent.
 
P

puiuluipui

Hi john, you are right. My folt!!! Sorry!

A1 and B1 are merged together and below i have 2 cells with numbers ,and i
need to extract the second cell.
Ex: -this is what code is doing now-
The code is in C8 and extract 125
A1=september
A2=125

This is what i need:
The code is in C8 and extract 425
A1=september
A2=125 B2=425

Can this be done?
Thanks and sorry!




"John Bundy" a scris:
 
L

Luke M

It sounds like you need to offset your summation range by 1 column.

=IF(SUMIF(A1:L1,TEXT(TODAY(),"mmm"),B2:M2)=0,"No
Entry",SUMIF(A1:L1,TEXT(TODAY(),"mmm"),B2:M2))
 
P

puiuluipui

This is perfect!
Thanks allot!

Luke M said:
It sounds like you need to offset your summation range by 1 column.

=IF(SUMIF(A1:L1,TEXT(TODAY(),"mmm"),B2:M2)=0,"No
Entry",SUMIF(A1:L1,TEXT(TODAY(),"mmm"),B2:M2))

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top