View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chickalina chickalina is offline
external usenet poster
 
Posts: 28
Default SUMIF with Multiple Criteria

=SUMIF(D3:D3001,"014",
G3:G5000)+SUMIF(I4:I10,"<"&DATE(2009,1,1),G4:G10)-SUMIF(I4:I10,"<"&DATE(2009,1,31),G4:G10)

what's wrong with this code? I'm looking to sum everything for building 14
(located in column D) from January 1 to January 31 (Located in column I).
Column G is where the monetary values are....

Thanks for any help!
M