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