# Get instant live Excel expert help figuring out how to use SUMIF

“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 need help doing a VLOOKUP and SUMIF for two different excel worksheets that include different questions.
Solved by O. J. in 30 mins
Greetings, I need help creating a sumIf and countif formula. Also need help interpreting the sheet. Will provide more information. Thanks!
Solved by F. H. in 12 mins
Could you help me to understand when sumif & countif are using?
Solved by G. C. in 25 mins
I need help with creating a formula to add values but excludes values when there is a certain value in another cell. i have tried the SUMIF but cant seem to get it!
Solved by D. H. in 13 mins
I have a spreadsheet of customers, with columns for whether they are wholesale or retail, their total cost for each order, the cost of items, cost of shipping, and any applicable sales tax cost. I did a SUMIF function to get total sales without sales tax, but I want to get Excel to copy rows with sales tax entries >0 into new rows at the bottom of the spreadsheet or even to a different spreadsheet. Alternatively, I'd like to be able to sum the column for the cost of items only for those sales which were subject to sales tax. I'm trying to use multiple criteria for the SUMIF function and it's just not working!. Can anyone help?
Solved by M. B. in 24 mins
An expert gave me help before but now have an error that I cannot fix... the formula is =SUMPRODUCT(SUMIF(INDIRECT("'"&Sheets&"'!"&"A:X"),A3,INDIRECT("'"&Sheets&"'!"&"R:R"))) and it picks up work sheets from a defined range - but now I have added extra sheets there is a ref error.
Solved by S. Q. in 26 mins
An expert gave me help before but now have an error that I cannot fix... the formula is =SUMPRODUCT(SUMIF(INDIRECT("'"&Sheets&"'!"&"A:X"),A3,INDIRECT("'"&Sheets&"'!"&"R:R"))) and it summaries hours worked from a range work sheets (defined range) and by searching for the person - but now I have added extra sheets there is a #ref! error.
Solved by E. C. in 25 mins
I am needing some help with a formula to sum data numbers across multiple entries. I have played with the sumif formula, and it does what i need, but only with one column of "range". I am needing to do this across 22 columns of "range". I have an example of what I am trying to do to show.
Solved by T. J. in 21 mins
I need to sum certain rows from a big table and I have an identifier for it, so not sure how to combine the vlookup and sumif for it, therefore, need some help
Solved by I. S. in 26 mins
I need to sum multiple columns with multiple rows based on criteria. I'm currently using a SumIf with offset formula. However, instead of returning the sum with the 12 columns I intend, it's only returning the sum of the first column in the array. Please help!
Solved by X. C. in 18 mins