AboutPricing

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.
< Go Back

    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