Use wild card character:* represents any number of characters : Database functions « Database functions « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Database functions
3. Database functions

Fill the data

Fill the criteria:="=K*"

Fill the formula: =DSUM(A1:C4,"Salary",D1:D2)

Press Enter to get the result

~* represents *

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