Thread: How do I use wildcard characters in Excel 2003 sumif formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default How do I use wildcard characters in Excel 2003 sumif formula?
Try this:

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

Does that help?

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

XL2002, WinXP-Pro


"Erik T" wrote:

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?
Reply With QuoteReply With Quote