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

I would like column E2 to sumif based on the sales rep in column D and the date range in Column A based on date in Column C
Solved by O. E. in 20 mins
I am using a sumif formula to Sum the quantity of products ordered between a specific date and time stamp. On the raw data tab, I want to sum Line Item Quantity (Column B), when two criteria are met: the LineItemSku = SF12OZMED, and the date ordered is between 5/17/2017 06:01:00 and 5/22/2017 06:00:00. I'd like the sum to be placed on the tab titled: SF - Fulfillment Manifest in cell F 3.
Solved by X. Y. in 27 mins
I'm trying to work on sumif in excel and pivot tables.
Solved by T. J. in 16 mins
I am trying to copy down this formula but I only want the G criteria to incriment and the rest of the formulato remain the same..... how can I make this happen SUMPRODUCT(SUMIF(INDIRECT("'"&A1:A3&"'!B3:B105"),G8,INDIRECT("'"&A1:A3&"'!D3:D105")))
Solved by V. L. in 30 mins
I work for a newspaper. We have a storylog with a batch of URLs but its missing google analytics data. The google analytics data has been imported on another sheet, but I need to be able to merge data using a common URL. The main problem is that analytics pulls tons of duplicate strings..... e.g. and then When I try to use a SUMIF function, it only sums the exact matches "". I've tried with approximate matches, but nothing seems to work. Please help!
Solved by S. C. in 22 mins
I have a tab (summary) which contains a table with a SUMIF formula to calculate the quantities sold of certain items contained in a second tab (detail). I would also like to be able to analyse this by the week that the product was sold, but unsure how to deal with the introduction of a third variable here. Thanks!
Solved by C. F. in 11 mins
In my workbook each tab is used for calculating material orders, each route has a tab, I need to create a summary page that adds up all orders by product, a simple sum will do. Here is the formula I am currently using, =SUMPRODUCT(SUMIF(INDIRECT("'"&sheets&"'!A8:d38"),C10,INDIRECT("'"&sheets&"'!g8:h38"))) I am willing to simplify, I just need this to work!
Solved by V. D. in 23 mins
I have a complicated SUMIF problem I think: I want to sum the values in a column only if in 2 other columns, numbers match each other. I.e. if value in A2 matches A3 AND value in D2 matches D3, I want the sum of numbers in C1:C4 added. I've uploaded version of spreadsheet with all columns but with most of the records deleted (it's a large file with >100k records). In my spreadsheet, I want column FK to add up the numbers in column ES only when the values in column A match each other and the values in columns DN match each other.
Solved by E. H. in 19 mins
I am having trouble with sumif excel and have no idea what to do next
Solved by D. F. in 30 mins
I want to do a sumif to add sales for a specific date so the condition would be say 6/15/17. I want to be able to pull the formula down and have the date automatically change to 6/16/17. Can this be done. I don't want to have to edit each cell
Solved by D. W. in 14 mins