Overview Chat Bike Members News Women
Viewing 3 posts - 1 through 3 (of 3 total)
  • excel help
  • seosamh77
    Free Member

    How do I tell it to dived by the number of cells in a row, defined by if it has value entered?

    ie

    ie row 5. columns M to AF are the values I want to count, but if only 6 of them have a value entered, I want it to divide by 6, if 10 values I want it to divide by 10, etc etc etc

    Posted 6 years ago
    seosamh77
    Free Member

    Got it. 😆

    COUNTA(M5:AF5)

    very helpful, cheers troops!

    Posted 6 years ago
    luket
    Full Member

    You could use count or countif to count the number of cells in which a condition is met. Then divide by that.

    Posted 6 years ago
Viewing 3 posts - 1 through 3 (of 3 total)

The topic ‘excel help’ is closed to new replies.

Overview Chat Bike Members News Women