Thread: sumif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kelly Kelly is offline
external usenet poster
 
Posts: 132
Default sumif

I have a spreadsheet with a list of invoice dates and the amounts due. At
the bottom, I have due dates a week apart
08/03/07
08/10/07
08/17/07
08/24/07
08/31/07
If the invoice date is equal to or less than 08/10/07 and greater than
08/03/07, I would like to include it in my SUMIF. Everything I have tried
(sumif and sumproduct) have produced $0 values.

Here is an example of the latest formula I've found here on the discussion
boards that I've tried to use.
=SUMPRODUCT((A4:A340C344)*(A4:A340<=C345)*F4:F340 )
Help, please.
kelly :)