Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Count rows from 2 columns when sum between 2 cells is non-zero in Excel

I want to count the rows when sum between cells of C and D columns is non-zero (i.e. greater than 0). As shown in image, I want to calculate value using formula which should be 3.
I tried countif and countifs formula, but not giving expected result.

Any help would be appreciated.

enter image description here

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

>Solution :

Try:

=SUM(N(MMULT(C2:D5,{1,1})>0))
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading