I've seen several examples of nesting subtotal in a sumproduct calculation and have played around for a few days, but do not know the lingo and concepts well enough to proceed any further. With a lot of help, I have been able to work through all but these two problems. Any suggestions?
=quartile(E23:E1000,1)
and
=sumproduct((B23:B1000<>"")/Countif(B23:B1000,B23:B1000&""))
Bookmarks