Help with formula

  • Thread starter Thread starter leave alone
  • Start date Start date
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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
 
Back
Top