Help with formula

L

leave alone

I need to edit this formula 2 ways
=COUNT(J1:J5)
first way I need it to count any cell with a value lower then 10 as 1 and
any cell with a value of 10 or higher as .75

For example if cells j1 to J4 are all valued at 6 but cell J5 is value at 11
the total I get would be 4.75


Second formula I need is to count J1 to J5 only the cells with a value of 10
or higher as .25

For example if cells J1 to J4 are all valued at 6 but cell J5 is value at 11
the total I get would be .25
 
N

Norman Harker

Hi Leave Alone!

First problem:
=COUNTIF(J2:J6,"<10")+COUNTIF(J2:J6,">=10")*0.75

Second problem:
=COUNTIF(J2:J6,">=10")*0.25

Do you really want us to leave you alone? We tend to use real names
here. It's more friendly.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
J

JE McGimpsey

Just for giggles, and because it involves one less function call, note
that if all the cells in the range have values, that this reduces to

=5-COUNTIF(J2:J6,">=10")/4
 
Top