Get instant live Excelp expert help figuring out how to use a SUMIF formula

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.

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")))

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!

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!

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

I have a source data sheet and I working on a summary sheet to pull data together. e.g.: Summary Tab Date range; 1.7.17 - 31.7.17 Shirts Dress Skirts On source document - I have individual lines which are coded to the above categories and other sub-categories, with delivery dates. the source doc dates range over 12 months I want to be able to paste in updated source data & have the summary page update - changing the date range above to move through months. The basic category SUMIF are fine. But when I need to sort by both the Category & then again by sub-cat I get error. I also need a formula that adds up only the numbers in that category with a delivery date within {that range}?? Can you help?

Hi, I have a SUMIF formula which matches to a series of numbers i.e: =SUMIF(E7:E200,"1.1",F7:F200) +SUMIF(E7:E200,"1.2",F7:F200) +SUMIF(E7:E200,"1.3",F7:F200) ect +SUMIF(E7:E200,"1.10",F7:F200) Problem i'm having is it cant distinguish between 1.1 and 1.10 it counts them both. I can omit 1.10 from the list but then i'll have to re-arrange all of my records. Ive tried changing the format to text, general, number and changing the amount of decimals but still doesn't distinguish between the two. Any ideas?

I have a large pivot table of customers, I need to sum when there are new customers and in reverse, when customers leave. Not sure if this can be done through pivot table. I just can't figure out the best way to do this with a sumif formula

I have a countif formula that works just fine. Then I realized I needed a sumif formula to include the quantities. This works: =IF(COUNTIFS(SalesRaw!AA:AA,$X$1,SalesRaw!AB:AB,V4,SalesRaw!AC:AC,W4)=0,"",COUNTIFS(SalesRaw!AA:AA,$X$1,SalesRaw!AB:AB,V4,SalesRaw!AC:AC,W4)) This doesn't: =SUMIFS(SalesRaw!N3,SalesRaw!AA:AA,PriceListRaw!$X$1,SalesRaw!AB:AB,PriceListRaw!V3,SalesRaw!AC:AC,PriceListRaw!W3) can you explain why?

I am trying to write a sumif formula with dates. I have a range of dates in column A and sets of figures in other columns. I want to sum the figures in a particular column if the dates in A are between 1st-30th April, for example. Spent all afternoon swearing at it so far!