In the above example, we have values in 10 columns and we have calculated the values which are greater than 1000. i.e. 4488, 1298&1902 and the formula has not considered -1200 since it’s a negative value.
March 3, 2010
Counting of values that’s greater than a value:
If we have a large set of data and we would like to count the larger values those are greater than a given value and we can do that using COUNTIF formula. Please have a look at the below example and the formula.
In the above example, we have values in 10 columns and we have calculated the values which are greater than 1000. i.e. 4488, 1298&1902 and the formula has not considered -1200 since it’s a negative value.
In the above example, we have values in 10 columns and we have calculated the values which are greater than 1000. i.e. 4488, 1298&1902 and the formula has not considered -1200 since it’s a negative value.
Subscribe to:
Post Comments (Atom)
great idea
ReplyDelete