formulas not working

[JOEE1979]

For some reason when I enter formulas, they are not being calculated.
What am I doing wrong?

Steeprock Yard List.xlsm
	P	Q	R	S
30
31		DDS	=COUNTIF(F3:S12, ">8000")
32		MCI	=COUNTIF(F3:S12, "<3000")
33		TOTAL	=SUM(R31:R32)
34
Yard List

 

[etaf]

check the cell is not set to text
and there is not a space before the =

 

[JOEE1979]

check the cell is not set to text
and there is not a space before the =

no space, also, they are number format

 

[Georgiboy]

Try CTRL+¬ on your keyboard

 

[etaf]

just seen, you are counting a range F3 to S12
so need sumproduct - but for some strange reason , thats not working for me !!!!!!!!

 

[etaf]

ignore all that
I got it working with a countif and a countifs

BUT i had to put into a new spreadsheet - I just could not make the copy from XL2BB work

Book4
	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2
3
4
5
6
7				9000000
8
9
10	900000
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32													2
Sheet1

Cell Formulas
Range	Formula
R32	R32	=COUNTIF(F3:S12,">"&8000)

 

[etaf]

FYI
=COUNTIF(F3:S12,">8000")

I tend to use
=COUNTIF(F3:S12,">"&8000), as for some reason the previous formula with ">8000" I have had a lot of issues in the past , when using all within quotes , not sure why

BUT they both work in this instance on the data , IN A NEW Spreadsheet