sumif formula

R

Rohit

i want to use sumif formual with a text.

eg =sumif(A1:A100,"ACC*",F1:F100). is this possible
 
M

Ms-Exl-Learner

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
Are the parentheses the problem? 6
Use TODAY() function as the criteria in a SUMIF formula 1
Sumif & Countif 6
Looping through permutations 7
SUMIF evaluating blank DATE data 2
Using a SUMIF and Parsing to sum part of a cell 7
CountIf from multiple sheets in another workbook 4

Top