sumif between two date ranges

what is the formula to use if I'd like to add daily value between specific dates
for example
column A:
customer ID 1 (A1)
customer ID 2 (A2)

column B:
customer ID 1 start date (B1)
customer ID 2 start date(B2)

column C:
customer ID 1 end date (C1)
customer ID 2 end date (C2)

column D:
customer ID 1 amount for day1 (D1)
customer ID 2 amount for day1 (D2)

column E:
customer ID 1 amount for day2
customer ID 2 amount for day2

continue horizontally until day 365

How do I sum each customer daily value based on start and end date?
Thank you for any help

Hi and welcome to the forum

I think you need to re-think your layout here. With a better structure, you could probably use the COUNTIFS() and/or the SUMIFS() functions. Although you could probably use the SUMIFS() with your existing layout, a more structured table will be easier to manage and run calcs on.

I suggest you aqttach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Try this, copied down...
=SUMIFS(F2:Y2,$F$1:$Y$1,">="&D2,$F$1:$Y$1,"<="&E2)

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)