I have a range of cells with numbers them 1,1,1,2,3,1,3,3,1,1,1,
Its a long story but is there a way of counting the number of 3's without using countif - preferably with some way using simple sum formulas.
I'm am using this for a 'solver' problem and solver doesn't like countif.
thanks