Excel! How do I calculate the number of items in cell H19 for which there is aHealth shortage of goods?



The author posted a question in Programming

Excel! How do I calculate the number of items in cell H19 for which there is aHealth shortage of goods? and got a better answer

Response from
through autosummary: other functions-calculus-select the range in column H and the criterion of scarcity?

Response from 0[++++]
through autosummary: other functions-calculus-select the range in column H and the criterion is not enough

 

To answer the question:

Name*

E-mail:*

Reply text:*
Verification code (enter 22):*