Advanced Excel Formulas in AnyDB: COUNTIF(range, criteria)

Tips
1

You can count the number of cells or attached records that meet a specified condition. :nerd_face: :laptop:

As in the following example, the Support Issues Dashboard (parent) counts attached records based on their status in three ways: Open Issues, Issues in Analysis, and Closed Issues.

anydb_support_issues_dashboard_01
anydb_support_issues_dashboard_01676×580 24.3 KB

anydb_support_issues_dashboard_02
anydb_support_issues_dashboard_021183×523 58.8 KB

To do that:

  1. Click on the cell that will display the quantity.

  2. Go to the formula field.

anydb_support_issues_dashboard_03
anydb_support_issues_dashboard_031598×945 120 KB

  1. Add the formula: COUNTIF(range, criteria)
  • In this case, COUNTIF(C@CURRREC!N@BPP Support Request!D2, "Open")

anydb_support_issues_dashboard_04
anydb_support_issues_dashboard_041317×645 65.4 KB

  1. Press Enter.

  • Any change to the attached records’ status or their deletion will update the dashboard.

  • You can also block the cell from editing.

Benefits

Using the COUNTIF(range, criteria) formula, you can automate advanced calculations in dashboards in many ways, saving time and energy in the long term.

To see how to do more with the COUNTIF formula in AnyDB, check out our documentation.

2 Likes