Heya all!

I have a small problem regarding to excel. I have a formula:

=AANTAL.ALS(gegevens!F2:F294;G9)-(EN(gegevens!BA2:BA294>0))

Only this formula looks then at the fields that have the value "0" but my meaning of this formula is that i want to filter those "0" value out and that it counts the records that is actually more then >0.

So a little example:

Field:
1
0
2
0
4

This will give a total of 3 fields that have more then "0". This is the meaning of my formula only i have searched on google and these forums but still not found :(...

Can somebody help me? Thanks alot!

Kind regards,

Creegfire

*EDIT*

I am working with Excel 2000

I take it that you have some user-defined functions at play here? If so, then you may need to show the code of the functions to have much chance of a sensible answer.

However, if the formula works with ...EN(gegevens!BA2:BA294>0... to show all records which equal zero, then maybe play with the operator > to see if that alters the selection behavior. Maybe try = instead of >, or <>. Check to make sure you don't need some kind of separator (a comma maybe?) between the range and the criteria.

Maybe someone else can provide a better response though.