How do I use wildcard characters in Excel 2003 sumif formula?

E

Erik T

When I use SUMIF(A1:A23,C3*,D1:D23), I get an error not allowing me to use
the wildcard character. How do I get this function to work inside Excel
formula?
 
R

Ron Coderre

Try this:

=SUMIF(A1:A23,C3&"*",D1:D23)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top