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

I need help on how to use indirect function along with sumifs function in excel.

Solved by Z. W. in 15 mins

I have a problem regarding to How to Use the MOD Function in Excel

Solved by S. Y. in 22 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 have an excel project to do. It wants me to use the IF function to place the text "yes" in cells I4:I8 if the total is more than a certain number in B15. I don't know how to do this though.

Solved by G. H. in 12 mins

If A7 is equal to A20, you want to display the text "OK" in the cell; otherwise, display the text "RETRY" in the cell. (Hint: Use the IF function.)

Solved by F. A. in 16 mins