Use Excel to sum and count between times | Sum and count between times in Excel

In this Video Tutorial, I will show you how you can sum and count between two times in Excel, or how to sum and count during a certain time interval.

This is a very useful calculation technique if you have any data that has transactions occurring between two times or during a certain time span and you would like to perform calculations on this data.

Download Example Workbook below:

Related Videos:
Basics of SUMIF, COUNTIF, SUMIFS, and COUNTIFS:

How to Sum between dates using SUMIFS:

Excel Date and Time MasterClass:

Download Example files:

Sign up for our Newsletter:

Follow us on Social Media:

*****My online Excel Courses*****

#sumifs #countifs #sumif

[dinahojjati]

That is a life saver video for anyone working on a dissertation:)) thanks alot🌸

[morethanwordsnv]

I looked far and wide to find this. You are a life saver. You make it super easy. Excellent video!

[josephtodd]

I have looked at a fair amount of tutorials and they either didn’t work or I couldn’t really follow what to do. You my friend are a hero, easy to follow and worked first time. Thank you very much. Keep up the good work

[ExcelBonanza]

Hey Guys, If anyone has another solution for the problem that I illustrated on the Video, feel free to share it in the comments!

[haheyourdead]

Thank you, was struggling to get the times to show for the SUMIFS for a certain period of time while also sorting through what line they were showing as and how long they had stopped. Big help knowing that you need to put in the time part.

[keyur]

This is the solution I was looking for. thank you very much :)

[cynthiacheok]

Thank you for the video. However, could we do if we have the whole week data. How do we calculate for each 30 min for the next days?

[sathyaloganathan]

Hi there, am looking to achieve the same for averageifs with time interval between 15 & 30 minutes. I have different values for different time slots, I wanted to get the averagefor individual time intervals. Would you be able to post it? Thanks

[soniaglenkayla]

How do I sum by hour for a specific date?

[MrCepumz]

Hi, I’m struggling to get that formula work on my spreadsheet, I have inputted everything exactly the same and trying to pick data from sheet2 on the same document.
Is it because data in time is column inputted via formula when data being inputted in column next to it?

[stevenjohnstone]

Very helpful. This is staic data. But how would you do it for dynamic time data. Fo example I would like to do the same exercise foer a web connected data sheet of stockmarket data. I would like to sum the dynamic % move change data of all the companies on the Dax at ten minute intervals. But it would seem that Excel would not retain the sum created during an interval if the interval has passed because obviously it would nolonger be in the spreadsheet. Is there any way around this problem?

[AnandaKishoreBanerjee]

How can I get unique man power in sum and count between times.I have office 2010. I want to in function.

[gunjanpanchal]

hi very nice video, , what changes do i have make if has one hour interval

[AnandaKishoreBanerjee]

How can I get unique man power in sum and count between times.

[marcinescu]

how to do it using sumproduct in array ?

[pravinbhoite]

Hi...
If you provide formula link or attachment of of excel where formula is applied that will really helpful for me

[cd]

im using office 365, i believe this formula structure does not work anylonger? Can you correct me if I am wrong

[sia_ibk]

Hello, please how do I add two time intervals. There are not times, but intervals. For instance, 23:00 + 5:00 should result to 28:00 (28 hours)