value based on count (equation question)

N

noahwallach

Hi there,

I am trying to figure out how to do the following equation. So I have 4
numbers in a range that are greater than 0. so the equation is something
like =sum(a1+a2+a3+a4+a5/x). since there are four numbers greater than 0
then x=4.

What I'd like to be able to figure out is if I change the value in a4 to 0
then I would like the value x decreases by 1 to the value of 3. And if I
place a number that is greater than 0 in cell a5 then x increases by one to
the value of 5.

I am wondering how I can perform the above equation?

Cheers,

Noah
 
M

Mike H

Hi,

To count values >0 in a range try this
=COUNTIF(A1:A5,">0")

I don't understand what your trying to achieve with the formula

=sum(a1+a2+a3+a4+a5/x)

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change a value based on adding another cell 1
sum last 3 numbers greater that 0 in a range 0
Excel formula, sum the value cell and if empty cell left blank 0
Make the sum of cells no greater than X 0
Trendline equation and data do not match up 3
MS Excel - changing reference column value based on another column 2
Confusing Problem 2
Asterisk pointing to a footnote 3

Top