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 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
Last edited: