Sumifs using Date, Time, and other criterias

sue_shee20

New Member
Joined
May 22, 2020
Messages
3
Office Version
  1. 2016
Platform
  1. Windows
Hello,
I have a table of transactions that gets updated twice a day (7:00, 13:00). The 2nd update shows all the transactions from the 1st update along with any new transactions since the 1st update. I'd like to sum the latest Amounts using Date and Items field.
If there was only 1 update per day then a simple SUMIFS would work but I'm not sure how to make it sum the latest figures based on Date criteria of "5/21/2020" and Item criteria.

Any help is much appreciated.

Thank you

1590188282451.png
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sorry, the image above shows "Apple" as the criteria but it really should be "Oranges". Couldn't find a way to edit the original post. The answer would be 400.

1590188494925.png
 
Upvote 0
Have you tried =SUMIFS(C:C, B:B, F3, A:A, ">="&E3, A:A, "<"&(E3+1))

Thank you for the reply. However, the formula you suggested would return "600" where the correct answer is "400". This is due to the 2nd update including 2 lines of Oranges from the earlier update in the same day. I need to only show summation from the latest time stamp in that particular day.
 
Upvote 0

Forum statistics

Threads
1,213,550
Messages
6,114,265
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top