“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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