View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Johnson
 
Posts: n/a
Default Conditional subtotals

Hi Aladin,

Nice one!
Also works as =IF((A2<"")*(A2<A3),SUMIF(A:A,A2,B:B),"")
Shorter still!
I've never bothered with Excel's Lists stuff, but after reading your
reply it looks like I've been depriving myself of a handy feature.
Thank you.

Ken Johnson