I have a5:a50 range with formula trim(countif(Muster!$d1:$d30,"TOI") which
results into number of TOIs in
a5:a50 but when I try =sum(a5:a50) in cell a51, I get 0.
How comes? What goes wrong?
Ajit