Skip to Content
0
Former Member
Jun 27, 2016 at 10:18 AM

CountIf...my formula is not working...

47 Views

I need to count the number of names if the corresponding value is =>9000.

I wrote the following variable.

=Count([Name]) Where ([Value]>=9000)

In the below example, the answer should be 2.

But it is not working...

It returns 3, which is maximum number of names available in the object.

[Value] is string, but is turned to measurement, using the following formula

=ToNumber([Value])

Could any one please provide insight onto what I am doing wrong here...?

Attachments

screenshot.png (29.0 kB)