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
|