Use wild card character: ? represents any single character : Database functions « Database functions « Microsoft Office Excel 2007 Tutorial






Fill the data
Fill the data
Fill the criteria:="=K?te"
Fill the criteria
Fill the formula: =DSUM(A1:C4,"Salary",D1:D2)
Fill the formula: =DSUM
Press Enter to get the result
Press Enter to get the result

~? represents ?









14.1.Database functions
14.1.1.Database functions
14.1.2.Use the equals sign ="=entry"Use the equals sign =
14.1.3.Use the equals sign with textUse the equals sign with text
14.1.4.Use wild card character: ? represents any single characterUse wild card character: ? represents any single character
14.1.5.Use wild card character:* represents any number of charactersUse wild card character:* represents any number of characters
14.1.6.Use the equals sign with valueUse the equals sign with value
14.1.7.Use greater thanUse greater than