# Get instant live Excel expert help with SUMIF functions

“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

Need help with google sheets, im stuck using the sumif formula
Solved by V. J. in 23 mins
Sum and Average across multiple sheets. I'm quite adequate with excel but can't figures out how to do sumif and averageif across multiple sheets.
Solved by B. W. in 30 mins
I want to total the instances of football (soccer) matches ending in different scores at Half Time. I have 2 columns for HT score, for the home team and away team. I keep trying variations of countif, sumif, sumproduct if but if it works at all I seem to end up with a count of the instances of team scores rather than the instances of match scores, i.e. a 0-0 comes out as 2 (nils) instead of 1 (nil-nil)... add another score of, say, 1-0 and I end up with 2 or 3 (nils) depending on what I'm trying. I need a formula that manages to give me the instances of 0-0s, 1+ goals, 2+ goals, etc. In my file you can see where I enter score lines in the Scores tab... and where I need the formula in the Goals 4 tab - this currently is full of the formula that doesn't work.. except B4 and B5... I've just left it there in case there is an easy tweak rather than a full rewrite.
Solved by D. E. in 22 mins