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