count without countif

[methody]

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

 

[crazydragon84]

you can use an array formula with sum and if. =sum(if(Range=3,1,0)) and ctrl+shift+enter

 

[methody]

you can use an array formula with sum and if. =sum(if(Range=3,1,0)) and ctrl+shift+enter

Hi
thanks that a clever solution but I think any 'array' or 'if' formula is out too.

I may be asking for the impossible but I think it will require a cumbersome formula using lots of basic sum formulas

 

[crazydragon84]

can you have a helper column that just has if column A = 3 then 1, then sum that column?

 

[AhoyNC]

Maybe SUMPRODUCT

Excel Workbook
	A	B
1	1	3
2	1
3	1
4	2
5	3
6	1
7	3
8	3
9	1
10	1
11	1
Sheet