In this article, I’ll use two IF () functions to split a simple “database” sheet into multiple columns, based on a value in another column.

The DCOUNT function counts the cells that contain numbers in a field or column of records in a database. If the field option is absent, DCOUNT will count all records in the database that matches the ...