Forum Discussion

Jessica Somers's avatar
Jessica Somers
Copper Contributor
Mar 22, 2018
Solved

Countif function

=COUNTIFS(D3,F3,H3,J3,L3,N3,P3,">0")  Tried writing this formula but it will calculate as 0 and not count the individual cells listed if their number is greater than 0.   My cells are specific ...
Excel Desktop
Formulas & Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Mar 23, 2018

    Hi Jessica,

     

    COUNTIFS will not work in this case!

    You should use this formula instead:

    =(D3>0)+(F3>0)+(H3>0)+(J3>0)+(L3>0)+(N3>0)+(P3>0)

     

    Hope that helps

Jamil's avatar
Jamil
Bronze Contributor
Mar 23, 2018

Hi Jessica,

A simple short formula like this will do the job.  INDIRECT function is volatile. if you have many cells with INDIRECT function in it. it will slow down the workbook.

 

Frequency Function is very useful.

 

=INDEX(FREQUENCY((D3,F3,H3,J3,L3,N3,P3),0),2)

 

Resources