Database functions applications

There are powerful buildin function in excel which may by used with the databases for complex calcultions.  The commonly used database functions are DMAX; DAVERAGE & DSUM.

DSUM would be the used as dynamic formula where you want to get database values.  This functions gives the summation value of data which meets the critiria specified in the function.  The picture shows the sample application of the fuction.