Il giorno Wed 02 Jun 2021 10:50:37a, *Claus Busch* ha inviato su microsoft.public.excel il messaggio news:s97got$5dd$
1@dont-email.me.
Vediamo cosa ha scritto:
try:
=SUMPRODUCT(SUBTOTAL(3,INDIRECT("D"&ROW(5:10)))*(IF(E5:E10<>0,(D5:D10/E 5:E10),0)))
YES!
it works fine both in the small sample sheet and in big one, changing a few references
Thank you
--
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
-=- -=- -=- -=- -=- -=- -=- -=- - -=-
........... [ al lavoro ] ...........
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)