View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] iainking@gmail.com is offline
external usenet poster
 
Posts: 15
Default Find subtotals of 160 each

I must have been really tired yesterday. E2 should be
=IF($D2<$D1,C2,E1)

Iain