 # Get instant live expert help on how does sumif work “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

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
SUMIF won't work. I type =SUMIF(D11:D15,">50")
Solved by A. F. in 13 mins
What does =SUMIF(\$A\$2:\$A\$88, "1015",\$H\$2:\$H\$88) mean?
Solved by E. F. in 26 mins
=SUMIF(A1:D4, "*Excellent", E1:E4)? How does this function mean? If one cell contains an Excellent at B2, actually E2 was not added. Why?
Solved by S. Y. in 11 mins
Can't get a combination sumif formula to work.
Solved by E. F. in 29 mins