Counting the number of rows in the spreadsheet that meets a condition


(1 comment)

Assuming you enter the products in the spreadsheet, each row is a product with a production date and product code. Given that the date data in column A, the product code in column B, cell D14 is used to count the number of products in a day, for example, October 12, 2019.
We can use a very simple but highly effective formula, an array formula - a situation using advanced SUM function. Select a representative cell with required date data, for example A7. The resulting formula in cell D14 is as follows

=SUM(A:A=A7)




Press Ctrl + Shift + Enter (instead of just pressing Enter as usual).

Currently unrated

Comments

Bình Lợi Center 2 months, 2 weeks ago

Thanks for sharing your thoughts about Khu
dân cư bình lợi Bình lợi center bình chánh. Regards

Link | Reply
Currently unrated

New Comment

required

required (not published)

optional

required


What is 3 + 6?

required