Thread: summing values in a data table based on criteria in another column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default summing values in a data table based on criteria in another column
Hi Dave,

Something along this line :

=SUMIF(D2:C100,""& DATE(2006,7,31),J2:E100) -
SUMIF(D2:C100,""& DATE(2006,8,31),J2:E100)

HTH
Cheers
Carim

Reply With QuoteReply With Quote