You probably have either data type mis-matches or unseen whitespace
characters in your data.

See this:

http://contextures.com/xlFunctions02.html#Trouble

Although the page is related to a different function, the trouble it
describes applies to any and every application.

--
Biff
Microsoft Excel MVP


"Champskipper" wrote in message
...
I am trying to use SUMIF to add values in one column if there is a date
entry
in another column. The formula: =SUMIF(I6:I37,"="&H11,D6:D37) does not
work
- always returns zero. The date in H11 is the earliest date in the
worksheet.

Can someone suggest what I am doing wrong?
--
Champskipper