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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try this:

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

Does that help?

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

XL2002, WinXP-Pro
 
Back
Top