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

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