Hi,

I'm afraid that trying to work out you named ranges was a bit too much so if
you want this as named ranges then you'll have to convert it.

I would actually used cell references for the month (10) and the name CCC
but this should do what you require.

=SUMPRODUCT((MONTH(A2:A29)=10)*(B1:E1="CCC")*(B2:E 29))

Mike

"Txlonghorn76" wrote:

Last week I was I had asked for a formula that would give me the yesterday's
numbers for an employee that pulled to a Summary Sheet from a table in
another worksheet. I was given this awesome formula:
=index(tbl,match(Thisday-1,Dates,0),match(Tgt,Names,0))

I would like to tweak this formula just a bit so that it pulls the running
sum for the month instead of just 1 day.

Summary sheet:

09/10/2008
Name Yesterday's numbers MTD Numbers
AAA
BBB
CCC
DDD

Table to pull data from:

AAA BBB CCC DDD
09/09/2008 30 31 32 33
09/10/2008 34 35 36 37
09/11/2008 38 39 40 41
09/12/2008 42 43 44 45
09/13/2008 46 47 48 49
09/14/2008 50 51 52 53