AnyDB Tip: Excel Formulas in AnyDB

Tips
1

Weekly AnyDB tip :laptop:

You can use Excel formulas in AnyDB to automate tasks. As an example, let’s take the =COUNTIF(range, “criteria”) formula to count the number of cells that meet a specified condition:

  1. Select the cell where you want the result to appear

  2. Go to the formula field on the right side

  3. Add the formula: COUNTIF(range, “criteria”). Example:

    1. Range = cells with data (A6:A13)

    2. “Criteria“ = feature you want to count (cells with the word “Car”).

anydb-tip-updated
anydb-tip-updated2938×1938 376 KB

Watch a Quick Tutorial

You can also use other useful Excel formulas in AnyDB, such as:

  • SUMIF(range, criteria): adds the number of cells that meet a specified condition.

  • VLOOKUP(lookup_value, table_array, col_index_num, approximate_match): searches for a value in the first column of a table and returns a value in the same row from a specified column.

  • DAYS(end_date, start_date): returns the number of days between two dates.

See all the formulas and how to use them by accessing:

Excel Formula and Functions in AnyDB

2

perhaps you can extend the tip with getting/using a data-range from an other record from another template,

2 Likes
3

Thanks for your insight! Sure, we will have more advanced tips like this, in the next tip posts!

Stay tuned with us! Additionally, if you’ve got any question, please let us know!