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

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?
 
G

Guest

Try this:

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

Does that help?

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

XL2002, WinXP-Pro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I use the * wildcard in an array formula 4
Excel Wildcard in Excel array formula 0
How to avoid '*' being used as wildcard in SUMIF? 6
Find/Replace MSWord wildcard characters from within Excel 6
SUMIF function help 4
returning text; alternative to sumproduct/sumif? 4
how to use * wildcard in a sum(if((cond),range)) array formula 3
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4

Top