Hi

=SUMIF(A1:A365,"=" & TEXT(DATE(2006,n,1),B1:B135) - SUMIF(A1:A365,"<=" &
TEXT(DATE(2006,n+1,0),B1:B135)
, or
=SUMPRODUCT(--(MONTH(A1:A365)=n),B1:B135)

, where n is the number of month.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"irvine79" wrote in message
...
Any thoughts? I have spreadsheet that has this years dates running down
column A. I then have each day's corresponding production figure running
down
column B. I want to assign a function to a cell that will result in the
months cumulative production figure. (I realize I can manually select the
desired Column B cells, but this is not the solution I am looking for)

The formula I have come up with so far is:

=SUM(LOOKUP(TEXT(TODAY(),"mmm"),TEXT(A1:A365,"mmm" ),B1:B365))

For some reason the result is 0. I used the formula auditing tool and came
up with nothing. Any thoughts?

Thanks