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


(0 comments)

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

There are currently no comments

New Comment

required

required (not published)

optional

required


What is 10 - 5?

required