View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Help with formula

=IF(B3="","",MAX(B3-SUMIF('Sent to Assembly'!A:A,A3,'Sent to Assembly'!B:B),))
Is there any way to change this formula to when there is a date next to it
(columnD) it will only count those date that are the same, and so on.
Example: All dates that are the same do calculation for that date