Hi People,

I have the below in a Table:
ColA ColB ColC
A 2.5 2.5
B 5 5
A 6 6
A 200 0
B 2 2
C 36 36
D 150 0
E 56.96 56.96
F 8.9 8.9
E 125 0
D 5 5
D 8 8

I'm after a formula that will Sum ColB where ColC <> o and this result will change to only include visible rows when ColA is filtered.

Thanks,