DataBase Functions

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

I am just starting to look at the data base funtions in excel. I a
wondering if anyone can tell me the advantage of using them verses th
regular functions that one can use on an array such as:

Sum
Average
Count
Counta
Offset
Lookup
Index

Are they simply an alternative with simpler syntax or are they faster?

Thank
 
Monkey,

The database functions work on a table, and use a criteria statement. This
allows, for example, DSUM to sum all the values in a particular column where
another column matches the criteria. E.g.: Sum all the expenses (column)
where the department column = Manufacturing.
 
Back
Top