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!