Hi,

Please see example I just want to have a formula on left
on column B that will count all values in column A

Note column A is the sum of C and D.


column AcolumnB columnC columnD
A+B b b
2 1 1
#VALUE! c c
2 1 1
2 1 1
#VALUE! 1 1
#VALUE! c c
2 1 1
2 1 1


Thank you