hi, quick question what is the function to add number freq greater than say 10 (example below)...
2 <(2 numbers are gearter than 10 thats "12" and "15")
12
10
15
5
8
thanks for any help given,
hi, quick question what is the function to add number freq greater than say 10 (example below)...
2 <(2 numbers are gearter than 10 thats "12" and "15")
12
10
15
5
8
thanks for any help given,
The FREQUENCY function ?
or maybe sumif()?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
thanks, but how would these function be use to get the correct result (see above)!
If your numbers are in column A try
=SUMIF(A:A,">10")
Audere est facere
it only returns the total sum of numbers above 9... close but not a solution.
I need the values 2 which mean two number or so has appear above 9 i.e:
2 <(2 numbers are gearter than 10 thats "12" and "15")
12
9
15
5
8
OK, that sounds like COUNTIF then
=COUNTIF(A:A,">10")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks