COUNTIF not working

[surkdidat]

In my DEV tab I have a column which includes a look up that will be £0, <£10,000, <£100,000, <£1,000,000, <£10,000,000 or >£10,000,000.

The formula I am using is

=COUNTIFS('DEV WIP'!J:J,"<£10,000,000")

- however, this is not counting - please help!

 

[Scott T]

When you put "" around a number it becomes text. "1" does not equal 1 since one is text and one is a number
try

[COLOR=#000000][COLOR=#0000bb][/COLOR][FONT=Courier New][COLOR=#007700]=[/COLOR][COLOR=#0000bb]COUNTIFS[/COLOR][COLOR=#007700]([/COLOR][COLOR=#dd0000]'DEV WIP'[/COLOR][COLOR=#007700]![/COLOR][COLOR=#0000bb]J[/COLOR][COLOR=#007700]:[/COLOR][COLOR=#0000bb]J[/COLOR][COLOR=#007700],[/COLOR][COLOR=#dd0000]"<"&10000000[/COLOR][/FONT][COLOR=#007700][FONT=Courier New])  [/FONT]
[/COLOR][COLOR=#0000bb][/COLOR][/COLOR]