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

Hi, Need help with a SUMIF formula, I cann
Solved by Z. A. in 23 mins
I have a data table, one column is months.... Hundreds of rows for each month. Each row contains a different item number. I am trying to consolidate to another table, by month, by item number. I know it is 2 hypotheticals, maybe a sumif... Help
Solved by O. J. in 11 mins
Need help with google sheets, im stuck using the sumif formula
Solved by V. J. in 23 mins
simple sumif problem that I just cannot figure out.... please help
Solved by K. H. in 24 mins
I need a formula to put in the column B in the COST SUB TAB, calculating excel table subtotal per resource from Column B in the Cost Plan tab (the result needed is similar to a Pivot TableNot with Resources in the Row and the Sum ofForecastedUnits in the values, however i would like a formula instead the pivot table for a similar result). Not sure if it's the SUMIF formula + vlookup the most appropriate or somethingelse. Please help me.
Solved by F. D. in 29 mins
I need a formula in the 2nd tab, to calculate the subtotal per resource from the 1st tab. Not sure if it's the SUMIF formula + vlookup the most appropriate or somethingelse. Please help me.
Solved by V. E. in 27 mins
I need help with a SUMif / Count if formula that works with text values. It's for a game.
Solved by Z. B. in 23 mins
I would like to take all of my transactions from last year and filter out certain retailers i.e. The Home Depot I've tried the sumif function but i get a 0 value, please help
Solved by S. Q. in 28 mins
Hi, I'm trying to find out the number of specific operations (Criteria in column) we'll have within a specific date range (criteria in row). To my knowledge, some form of sum or sumif is required along index and match. Any help would be appreciated. In the file attached, I am trying to find out how many Operational days we'll have in FY2018 (cell Q12), within the date range (N12:O12), for a specific operation type (P12).
Solved by A. A. in 21 mins
I need help with excel sumif greater than and from a different sheet.
Solved by D. J. in 14 mins