Hi,
Am Wed, 2 Jun 2021 08:17:46 -0000 (UTC) schrieb Ammammata:
> I'm trying to (matrix) sum a column, where I have a filter, but it doesn't
> work
>
> =SUM(IF(E5:E10=0;0;D5:D10/E5:E10)) Ctrl-Shift-Enter is Ok, but it works on
> the whole range
>
> but
>
> =SUBTOTAL(9;IF(E5:E10=0;0;D5:D10/E5:E10)) Ctrl-Shift-Enter fails with
> #VALUE! error
try:
=SUMPRODUCT(SUBTOTAL(3,INDIRECT("D"&ROW(5:10)))*(IF(E5:E10<>0,(D5:D10/E5:E10),0)))
Regards
Claus B.
--
Windows10
Microsoft 365 for business