Computer Science, asked by jaatryaan4152, 1 year ago

What is formula to count number cell which contains cell value greater than 0 in excel

Answers

Answered by zip1819

2

=countif(range of cells,">0")

Example

=countif(a1:a20,">0")

it will count the number of cells from a1 to a20 whose value if >0.

All the best.....

Previous Question

Next Question

Similar questions

Science, 6 months ago

mention few precautions to be taken to aviod covid-19 infection and measure should be taken if one gets infected.

Math, 6 months ago

Raju wrote a no having 2 digit where the digit in the ten position is thrice the digit in the unit position and the new no obtained by reversing the position of the digit is 36 less than the initial no. find the number written by raju...

English, 6 months ago

do you relate yourself with the boy in the video? If so, how?

English, 1 year ago

What pen name was adopted for the book ‘Bravo Two Zero’?

Chemistry, 1 year ago

What does the value of a in van der waals equation...

Biology, 1 year ago

proper cleaning and shelter facilities are essential for the health of animal and production of clean milk,.justify the statement.

Chemistry, 1 year ago

mass of one molecule of CO is: A). 1.01×10²³ B). 2.01×10²³ C). 3.65×10²³ D). 7.31×10...

Biology, 1 year ago

How Are The Alveoli Dedigned To Maximise The Exchanging The Gas?