Is it possible for an Excel formula to calculate a sum based on date ranges?

R

ruby9c

New Member
Joined
Nov 20, 2024
Messages
2
Office Version
  1. 365
Platform
  1. Windows
I need to calculate the number of credit hours in column B by a date range from 2/1/2023 to 2/1/2026.

When I competed the sheet, it will include dates before and after the range above. I'll need a formula that can calculate the sum of column B based on the dates in column C.

I have used SUMIF formulas, but I can't figure out how to add in the date range.

Thank you for any help!


Employee Name
Total Credits 2/1/2023 - 2/1/2026 :
Requirement: 20 credit hours in 36 months
Continuing Education CoursesCredit HoursDate Completed
EPA 2023 Inspector Workship610/4/2023
2024 Spring Bureau Inspector Training - API15.53/7/2024
FD9001W Sanitary Transportation of Human & Animal Food Rule13/15/2023
EPA 2024 Inspector Workship4.510/11/2024
FDA Form-2481 Training111/14/2024
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
Thank you!

I tried following the example in the SUMIFS example. The formula isn't working, but now that I know it's possible I will keep trying.
 

Attachments

  • Screenshot (209).png
    Screenshot (209).png
    151.7 KB · Views: 5
Upvote 0
This should help.
Book1.xlsm
ABC
10Employee Name
11Total Credits 2/1/2023 - 2/1/2026 :
12Requirement: 20 credit hours in 36 months
13Continuing Education CoursesCredit HoursDate Completed
14EPA 2023 Inspector Workship6,0004.10.2023
152024 Spring Bureau Inspector Training - API15,5007.03.2024
16FD9001W Sanitary Transportation of Human & Animal Food Rule1,0015.03.2023
17EPA 2024 Inspector Workship4,5011.10.2024
18FDA Form-2481 Training1,0014.11.2024
1928
Слияние1
Cell Formulas
RangeFormula
B19B19=SUMIFS(B14:B18,$C$14:$C$18,">"&DATE(2023,2,1),$C$14:$C$18,"<"&DATE(2026,2,1))
 
Upvote 0
ruby9c said:
Thank you!

I tried following the example in the SUMIFS example. The formula isn't working, but now that I know it's possible I will keep trying.
Click to expand...
In your formula in your screen print, you actually entered in G7 where it should be G6.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
Calculating a YTD Balance based on end date?
Replies
2
Views
78
des378
D
M
  • Solved
Formula to calculate length of the contract using Begin date and end date
Replies
5
Views
460
Micron
M
M
  • Question Question
Index Match function List based on date
Replies
7
Views
271
Fluff
Fluff
Kellie220
  • Solved
Formula for calculating different dates/ VBA
Replies
3
Views
687
awoohaw
awoohaw
C
  • Question Question
SUMIFS if a date is within the range
Replies
1
Views
668
Fluff
Fluff

Forum statistics

Threads
1,223,841
Messages
6,174,970
Members
452,594
Latest member
dgparryuk

Share this page

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