SUMIF criterion to match the first 5 characters.

  • Thread starter Thread starter Fred Holmes
  • Start date Start date
F

Fred Holmes

Excel 2000

How do I write a SUMIF function, such that the matching text criterion
matches the first five characters of the string in the cells of the
range to be evaluated for a match? Something like the following:

=SUMIF(LEFT(A5:A1000,5),"Total",C5:C1000)

Many thanks,

Fred Holmes
 

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

SUMIF Criterion with NOT 7
returning text; alternative to sumproduct/sumif? 4
SUMIF on a collection of individual cells 9
SUMIF partial string criteria 4
make criteria in sumif refer to another cell 4
Help to pick string value if match happens 1
select multiple cell ranges in "sumif" formula? 1
multiple criterion to give sum 3

Back
Top