sumif formula

  • Thread starter Thread starter Rohit
  • Start date Start date
R

Rohit

i want to use sumif formual with a text.

eg =sumif(A1:A100,"ACC*",F1:F100). is this possible
 
I don’t know what difficulty you are facing since the formula is correct. The
formula you have mentioned in your above post will get you the sum value of
the text which are all starting with “ACC†in A1 to A100.

If this post helps, Click Yes!
 

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 formula 1
Filtering with SUMIFS 1
nested sumif 5
Looping through permutations 7
SumIf Question 2
Using SUMIF with AND 2
Sumif less than x 3
Two formulas in one cell 1

Back
Top