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

“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 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 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 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 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
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?
Solved by X. H. in 29 mins
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?
Solved by O. Q. in 20 mins
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
Solved by X. S. in 17 mins
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?
Solved by D. Q. in 28 mins
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!
Solved by D. E. in 24 mins