View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stevec stevec is offline
external usenet poster
 
Posts: 177
Default Sumif with multiple conditions

We need to sum data in a spreadsheet where multiple conditions apply.

C2:C400 is quantity data
J2:J400 is received date
K2:K400 is due date.

We want to sum the data in column c if the received date for a given record
is in a given month (which will change every report cycle), and the due date
for a given record is in any month following the received date month.

I can write a separate formula for each condition but that doesn't
necessarily help. When I try to structure a sumif using multiple conditions,
I just end up with errors.

Any help in understanding how to do it will be appreciated.