Marcster
01-15-2016, 02:39 AM
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,
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,