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

[ruby9c]

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 Courses	Credit Hours	Date Completed
EPA 2023 Inspector Workship	6	10/4/2023
2024 Spring Bureau Inspector Training - API	15.5	3/7/2024
FD9001W Sanitary Transportation of Human & Animal Food Rule	1	3/15/2023
EPA 2024 Inspector Workship	4.5	10/11/2024
FDA Form-2481 Training	1	11/14/2024

 

[Joe4]

Welcome to the Board!

You need SUMIFS, not SUMIF.
See here for details and examples: Excel SUMIFS date range formula - sum if between two dates

 

[ruby9c]

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.

 

[Sergius]

This should help.

Book1.xlsm
	A	B	C
10	Employee Name
11	Total Credits 2/1/2023 - 2/1/2026 :
12	Requirement: 20 credit hours in 36 months
13	Continuing Education Courses	Credit Hours	Date Completed
14	EPA 2023 Inspector Workship	6,00	04.10.2023
15	2024 Spring Bureau Inspector Training - API	15,50	07.03.2024
16	FD9001W Sanitary Transportation of Human & Animal Food Rule	1,00	15.03.2023
17	EPA 2024 Inspector Workship	4,50	11.10.2024
18	FDA Form-2481 Training	1,00	14.11.2024
19		28
Слияние1

Cell Formulas
Range	Formula
B19	B19	=SUMIFS(B14:B18,$C$14:$C$18,">"&DATE(2023,2,1),$C$14:$C$18,"<"&DATE(2026,2,1))

 

[Joe4]

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.

In your formula in your screen print, you actually entered in G7 where it should be G6.