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

Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Mar 23, 2018

Hi Jessica

 

There's a many solutions floating about online about capturing non-continguous cells, so I've pulled this formula for you which should do the trick:

 

=SUM(COUNTIF(INDIRECT({"D3","F3","H3","J3","L3","N3","P3"}),">0"))

 

I've also attached a sample file that I have mocked up.

 

Let us know how you go?

 

Cheers

Damien

Resources