R Rohit Oct 29, 2009 #1 i want to use sumif formual with a text. eg =sumif(A1:A100,"ACC*",F1:F100). is this possible
M Ms-Exl-Learner Oct 29, 2009 #2 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!
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!
