It would have been helpful if you posted your formula... then I wouldn't
have to ask you exactly what is in Column D... the month name as a spelled
out text word or the number of the month?

--
Rick (MVP - Excel)


"jeremiah" wrote in message
...
I export from Access to text and then import into Excel, the export from
Access truncates some ending characters. To offset this I have to sum
some
records once I get it to Excel but am having trouble with the following
sumif

If the value in column D is a Month (January, February etc) then sum only
those rows in column Q. I have figured it out as an Excel formula but how
is
this converted to vb?