# 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

Solved by C. J. in 23 mins
I'm trying to use SUMIF across multiple spreadsheets and keep getting an error.
Solved by B. Y. in 23 mins
I need explanation for the excel formula below... =IF(ISERROR(SUMIFS(INDIRECT("'"&BE\$6&"'!"&"\$G:\$G"),INDIRECT("'"&BE\$6&"'!"&"\$R:\$R"),\$A39,INDIRECT("'"&BE\$6&"'!"&"\$F:\$F"),"<>52711",INDIRECT("'"&BE\$6&"'!"&"\$C:\$C"),10)),0,SUMIFS(INDIRECT("'"&BE\$6&"'!"&"\$G:\$G"),INDIRECT("'"&BE\$6&"'!"&"\$R:\$R"),\$A39,INDIRECT("'"&BE\$6&"'!"&"\$F:\$F"),"<>52711",INDIRECT("'"&BE\$6&"'!"&"\$C:\$C"),10))+IF(ISERROR(SUMIFS(INDIRECT("'"&BE\$4&"'!"&"\$A\$30:\$EO\$30"),INDIRECT("'"&BE\$4&"'!"&"\$A\$4:\$EO\$4"),BE\$5,INDIRECT("'"&BE\$4&"'!"&"\$A\$5:\$EO\$5"),\$A39)),0,SUMIFS(INDIRECT("'"&BE\$4&"'!"&"\$A\$30:\$EO\$30"),INDIRECT("'"&BE\$4&"'!"&"\$A\$4:\$EO\$4"),BE\$5,INDIRECT("'"&BE\$4&"'!"&"\$A\$5:\$EO\$5"),\$A39))+IF(ISERROR(SUMIF(INDIRECT("'"&BE\$6&" "&\$A\$31&"'!"&"H:H"),\$A39,(INDIRECT("'"&BE\$6&" "&\$A\$31&"'!"&"I:I")))),0,SUMIF(INDIRECT("'"&BE\$6&" "&\$A\$31&"'!"&"H:H"),\$A39,(INDIRECT("'"&BE\$6&" "&\$A\$31&"'!"&"I:I"))))
Solved by V. A. in 15 mins
Hi, i have a spreadsheet which has 3 columns a = date b = time of day c = numerical result from a machine monitoring air pollution d = word describing where the person is at that time point i am trying to do two things 1. work out how long each person spends on each activity/place 2. work out total sum of the pollution monitoring for each activity i have tried sumif but it doesn't seem to work?
Solved by D. Y. in 11 mins
The attach excel file is a line plan of 18 Lines. Formula is in: Column "AM" is style number & Column "AN" is quantity. In worksheet A1 to AK1 column what the style number I start from any date , any line or multiple lines the total quantity I can get it “AN” column by SUMIF formula. Need: Column "AO" start date of a style number. Column "AP" Close/End date of the SAME style number. Date is in Column “A” I show an example of style number ABC (In Red color) which Start from Oct 15 & Close on 9 Nov. Close date I get correctly for all styles. But Start date is not working correctly. Can you please check the formula and correct it
Solved by V. C. in 25 mins
If in the Sheet1 column H4 I have the following formula: = SUMIF (\$B\$4:\$B\$30,G4,\$C\$4:\$C\$30) So how to write the formula in the code? Please help.
Solved by D. W. in 17 mins
Hello, i am looking at a spreadsheet that is using sumif formula. I have little experience with this formula and do not understand what is telling me. The same formula is in several cells and returning numbers,but one particular line is not. =SUMIF('Compare-Total'!\$A\$6:\$A\$48,East!A19,'Compare-Total'!\$C\$6:\$C\$48)
Solved by G. C. in 21 mins
I have a sumif formula which returns a different number than if I do a sum on the same information. Any idea what would cause this?
Solved by K. B. in 23 mins
Need help summing a column of numbers compared against a cell in that column, then iterating through the column, comparing each cell. Using a sumif statement
Solved by V. H. in 11 mins
Hi, On Sheet 1 I have a sales rep id in column C (highlighted) The rest of the columns are revenue with the dates across the top. I would like to calculate the total each sales rep is worth. So add up all the rows with that rep ID. On sheet 2 I have created a small table where I will put my formulas and the calculation. What is the most efficient way to do this. I believe it is a sumif formula but I cannot get it to work? Thanks
Solved by T. J. in 18 mins