# 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. www.mywebsite.com/ and then www.mywebsite.com/index~214. When I try to use a SUMIF function, it only sums the exact matches "www.mywebsite.com/". 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