Counting only numbers

[#1]

Hey guys,

I have a file, .csv, and in that I have blank fields, which I don't know why it seems to count them, and I would like that not to happen... Can someone tell me how to?

Now I am using only "count([Labor Rate])

[Anonymous · Accepted solution]

Try the NumericCount() function.

[#3]

it does look better now, but i am not entirely sure of it, i was using like this:

='US$' &' ' & round(sum(If([Labor Rate]*Rate<200,[Labor Rate]*Rate/V_Count_LRate,)),1.0)

this if part it was to exclude some wrong data... this V_Count_LRate was just =count(LaborRate). The answer was = 98,

now, it's 87... Before I was using the exact same numbers from a .xls, divided in 12 files (one for each month), now I am using a single .csv for the whole month...

[#4]

what do you think it might have also changed?

[#5]

Never mind, I found out what the problem was!