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/E 5:E10),0)))
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 286 |
Nodes: | 16 (2 / 14) |
Uptime: | 88:27:59 |
Calls: | 6,496 |
Calls today: | 7 |
Files: | 12,100 |
Messages: | 5,277,326 |