In column E you may have a text number, or space

this formula will ignore text value

=SUMPRODUCT(--(MONTH(C1:C4)=3),E1:E4)



lunelmai" wrote:

Hi Rick,

Thank you very much for getting back to me so quickly.
I tried your formula, but it gives me a VALUE error...I'm using Excel 03 by
the way, I don't know if that changes anything.



"Rick Rothstein" wrote:

Try this formula...

=SUMPRODUCT((MONTH(C1:C100)=3)*(E1:E100))

Change the upper range row number (the 100 in my example formula) to the
largest row number you expect to have data in. Note that I hard coded the
month number (3 in my example formula), but you could use a cell reference
instead (that is, say, K5 in place of the 3 and put your month number in
that cell).

--
Rick (MVP - Excel)


"lunelmai" wrote in message
...
Hi everyone,

I hope someone will be kind enough to help me...

this is the data I have:

A B C D E F

1 56 1/19/08 12.0 14.8 23
2 98 2/24/08 58.2 21.8 12
3 73 3/12/08 88.2 78.1 08
4 24 9/11/08 78 21.3 85

I have about 900 entries in my sheet, and I need to pull the numbers from
the "E" column that are associated with a certain month (January to
December)
that appears in the "C" column. Ultimately, I will need to add the data
that
I found for each month, to come up with a total/month.

I've been trying to use some lookup functions, but none of worked out well
so far.

Does anyone have any suggestions??

Thank you!