Are they real dates or text dates?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bob Phillips" wrote in message
...
=SUMPRODUCT(--(TEXT(I5:I20,"mmmm")="June"),K5:K20)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"businesslady24"
<businesslady24.29t23c_1150982402.5185@excelforu m-nospam.com wrote in
message
news:businesslady24.29t23c_1150982402.5185@excelfo rum-nospam.com...

Hi I am trying to use sumif to collect date information for me. The
spreadsheet is basically a large list of jobs that have been carried
out with the date of job. I am trying to get excel to add up the
amounts for each job in march, each in april etc.

I have this as my spreadsheet
Col I____________________ColK
12th june 2006__________£46.24
18th may 2006__________£116.24

the formula i was using was SUMIF=(I5:I420, "june", K5:K20) for june
etc.
Can anyone see where i am going wrong? I don't think it is picking June
up on the search because the cell actually contains the whole date- day,
month, year, but these are necessary.

Thanks


--
businesslady24
------------------------------------------------------------------------
businesslady24's Profile:
http://www.excelforum.com/member.php...o&userid=35669
View this thread:
http://www.excelforum.com/showthread...hreadid=554535