Get instant live Excel expert help and learn how to SUMIF between two dates

“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 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
I have 10 worksheets that have identical row names and content. The columns are all dates. But each worksheet has a different date in column B. I want to consolidate those 10 worksheets into a consolidation tab such that the values in the columns will sum in the consolidated sheet based on matching up the specific date. The columns are headed with date values. I am trying to use the sumif function based on the criteria that the dates in the worksheets exactly match the date in the consolidated worksheet. Help
Solved by C. H. in 24 mins
So here is my issue. I'm using excel to calculate out the debt service that I need to support a hypothetical development, and the sumif function doesn't seem to want to work given the formulas I've setup. So the debt service is a basic amortization table debt service table over 25 years. But for the development I only need to be worried about the debt service on the loan through the period that I'm doing the development. In this case 8 months of the 25 year time frame. To get the schedule I setup a schedule that returns period dates based on the month and year. I think referenced that date using the following function: =INDEX('Project Schedule'!$1:$1,MATCH(G4,'Project Schedule'!$2:$2))+1 This references the months in Row 2, and returns the Period Value in Row 1. In this case returning the value of 14. but when I use a basic SumIf function to sum the total cost of the payments into the loan, it returns a "zero" value. Here is my sumif function SUMIF(A10:A410,"<=F4",G10:G410) Now if I just replace F4 with the value 14 it works and calculates correctly, but if I reference the cell F4 it returns a zero value. My only thought is that the Index function screws this up, and doesn't actually return a number value. Your thoughts?
Solved by K. H. in 22 mins
Hi, i have a spreadsheet which has 3 columns a = date b = time of day c = numerical result from a machine monitoring air pollution d = word describing where the person is at that time point i am trying to do two things 1. work out how long each person spends on each activity/place 2. work out total sum of the pollution monitoring for each activity i have tried sumif but it doesn't seem to work?
Solved by D. Y. in 11 mins
The attach excel file is a line plan of 18 Lines. Formula is in: Column "AM" is style number & Column "AN" is quantity. In worksheet A1 to AK1 column what the style number I start from any date , any line or multiple lines the total quantity I can get it “AN” column by SUMIF formula. Need: Column "AO" start date of a style number. Column "AP" Close/End date of the SAME style number. Date is in Column “A” I show an example of style number ABC (In Red color) which Start from Oct 15 & Close on 9 Nov. Close date I get correctly for all styles. But Start date is not working correctly. Can you please check the formula and correct it
Solved by V. C. in 25 mins
Question on a SUMIF formula: =SUMIF((H6:H494),">01/01/2017"and"<10/31/17,I6:I494) is not working for me. Trying to sum up all sales numbers within a date range of one month. Thank you
Solved by G. D. in 14 mins
I am trying to utilize a complicated sumif or sumifs formula that can pull a total amount from a date and a drop down box from another tab.
Solved by E. B. in 25 mins