I dont 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!

--------------------
(Ms-Exl-Learner)
--------------------



"Rohit" wrote:

i want to use sumif formual with a text.

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