You didn't say anything about "No Entry" in your original request. Try this
normally entered formula then...

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

You can change the "No Entry" text to whatever wording you want (just make
sure that text is enclosed in quote marks as shown for the "No Entry" text).

--
Rick (MVP - Excel)


"puiuluipui" wrote in message
...
Hi Rick, it's working, but i need the formula to display "No entry" or
some
text message if in cell 2 is nothing.
Can this be done?
Thanks!

"Rick Rothstein" wrote:

Assuming your January, February, etc. entries in A1:L1 are **text** (that
is, the spelled out names and *not* dates formatted to look like the
month
names), you can use this (normally-entered) formula...

=SUMIF(A1:L1,TEXT(TODAY(),"mmm"),A2:L2)

--
Rick (MVP - Excel)


"puiuluipui" wrote in message
...
Hi, i have in A1:L1 all the months. (january, february....)
Below every month i have cell with some numbers. I need in C8 to
display
numbers below curent month. If this month is september, then the code
to
look
in A1:L1 and find september and to display numbers below. If this month
in
october to find october and display below numbers.
Can this be done?
Thanks!