Get instant live Excel expert help figuring out why your SUMIF is not working

“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

My sumif forumla is not working. Obviously Vlookup's only find the first match so i am trying a sumif forumla to add up all the matches but it is not working
Solved by C. J. in 15 mins
Sum of data by product using a lookup value - i've got a complex sheet where i need to do a summary by product type but it's got to get the values from a lookup and i cant get my head around the calculation. I think its a sumproduct and sumif but the calculations just not working for me. can you help?
Solved by B. B. in 21 mins
I'm trying to build a spreadsheet that will take data from individual acquisitions. Can I share the spreadsheet and ask what is wrong with my formula? I'm using a SUMIF function, but it's not working.
Solved by E. B. in 18 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
Question on a SUMIF formula: =SUMIF((H6:H494),">01/01/2017"and"<10/31/17,I6:I494) is not working for me. Trying to use sumif date range for all sales numbers within a date range of one month. Thank you
Solved by G. D. in 14 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