Forum Discussion

ReeseT's avatar
ReeseT
Occasional Reader
Oct 22, 2025

Countifs help

im using countifs to keep track of the amount of times my criteria appears in row, but i'm trying to figure out how to make it count by .1 instead of by 1. Any helpw ould be greatly appreciated im slowly learning all the uses for excel.

2 Replies

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor

    What do you mean by .1? Count then divide by 10? Or something else? Would you please explain little more with few of a example?

     

  • m_tarler's avatar
    m_tarler
    Bronze Contributor

    divide by ten so something like:

    =COUNTIFS( ....) /10

Resources