Formula to sum a row through the current month

**Willardio** · 03-22-2013, 12:04 AM

Hello All,

I am looking for a formula that finds the name of the current month in at the top of a column, then adds all the numbers in the next row from the first column up to and including that column. The object is to track current production goals. Here's a sample, the formula belongs in cell N3:

current goal sample.xlsx

Thanks in advance,

Willardio

**FDibbins** · 03-22-2013, 12:16 AM

try this...

=SUM(INDIRECT("A3:"&CELL("address",OFFSET(A3,0,O2-1))))

**Willardio** · 03-22-2013, 12:32 AM

Hmm, I get "#REF." I also don't see where the function looks up the current month in row 2. So let's say today's date was may 3, 2013; I would want the value in N3 to be "5"...

**FDibbins** · 03-22-2013, 12:34 AM

oops my bad, sorry...you need to add this to N1...
=TEXT(TODAY(),"mmm")

My apologies

**kvsrinivasamurthy** · 03-22-2013, 02:14 AM

Try this.

Please Login or Register  to view this content.

**Pepe Le Mokko** · 03-22-2013, 03:15 AM

A solution with a minimum of volatile functions

Please Login or Register  to view this content.

BTW what will happen next month? As there are no years, XL will stop at the first instance of "Apr"

**Willardio** · 03-22-2013, 06:40 AM

Pepe, I need it to start over in April, not stop, and it looks like that is what will happen so thanks for the solution. And thanks to all of you for your suggestions, you're so smart!
All values in the table will be changed each April when a new contract begins. Hmm, maybe I should make Pepe wait nine days for his star, just in case... kidding!

Thanks again to all of you,

Willardio