# Get instant live expert help on sumif not equal to text

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

Hi, I need a sumif formula using a criteria that represents "is not equal to a certain cell value (is a text value), what's the syntax for this criteria?
Solved by Z. Y. in 23 mins
I am using a =SUMIF function, where i need the formula to read the text eg. "Expenses". How do I refer to a cell and for it to pick up the text. In this example, if A2="Expenses", I want to use "A2" in the =SUMIF function but it does not work.
Solved by K. F. in 12 mins
I need a formula like sumif but works with text.
Solved by E. J. in 24 mins
Need help with a Sumif formula to display text once the cell is over a certain value
Solved by M. H. in 17 mins
I need to use the SUMIF function to compute the sum of cells E6:E21 if the cell in the range D6:D21 is equal to cell K8
Solved by O. U. in 13 mins