Thread: SUMIF Criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Champskipper Champskipper is offline
external usenet poster
 
Posts: 4
Default SUMIF Criteria

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