Skip to content

Data Empower – The Data Matrix

Search for:
Log in

Menu

Close
  • Home
  • Shop
  • Excel
    • All Excel Functions List
  • PowerBI
  • SQL
  • Fabric
  • Google sheets
    • Google Sheets All functions alphabetical
  • About
  • Home
  • Shop
  • Excel
    • All Excel Functions List
  • PowerBI
  • SQL
  • Fabric
  • Google sheets
    • Google Sheets All functions alphabetical
  • About
Search for:
Log in

Category: Google sheets database

  • Home
  • Google sheets database
Google sheets database

DVARP Google Sheets function

Written by Data Empower May 18, 2025

Calculates the variance of an entire population drawn from a database table-like array or range using a SQL-like query.

Google sheets database

DVAR Google Sheets function

Written by Data Empower May 18, 2025

Calculates the variance of a population sample chosen from a database-like array or range with a SQL-style query.

Google sheets database

DSUM Google Sheets function

Written by Data Empower May 18, 2025

Calculates the total of values extracted from a database-like range or array using a query similar to SQL.

Google sheets database

DSTDEVP Google Sheets function

Written by Data Empower May 18, 2025

Calculates the standard deviation for an entire population drawn from a database-like array or range using a SQL-inspired query.

Google sheets database

DSTDEV Google Sheets function

Written by Data Empower May 18, 2025

Calculates the standard deviation of a population sample extracted from a database table-like array or range, utilizing a SQL-like query.

Google sheets database

DPRODUCT Google Sheets function

Written by Data Empower May 18, 2025

Calculates the product of values extracted from a database-like array or range using a SQL-like query.

Google sheets database

DMIN Google Sheets function

Written by Data Empower May 18, 2025

Retrieves the smallest value from a range or array that resembles a database table, applying a SQL-like query.

Google sheets database

DMAX Google Sheets function

Written by Data Empower May 18, 2025

Retrieves the highest value from a database-like array or range using a SQL-style query.

Google sheets database

DGET Google Sheets function

Written by Data Empower May 18, 2025

Fetches a single value from a database-like range or array using a SQL-style query.

Google sheets database

DCOUNTA Google Sheets function

Written by Data Empower May 18, 2025

Counts entries, including text, drawn from a database-style array or range using a SQL-like query.

Page navigation

1 2 Next
Follow me on Ganjing World!

Get the SQLBits T-Shirt now!

Copyright © 2025 Data Empower - The Data Matrix | Powered by BuddyX WordPress Theme

We noticed you're visiting from Germany. We've updated our prices to Euro for your shopping convenience. Use United States (US) dollar instead. Dismiss