Feb 21 2022 02:22 AM
Was wondering if there was a way to add a date. So lets say I don't want it to generate a sum unless it is for a specific date or for specific days in the week. Is it possible?
Feb 21 2022 02:34 AM
Let's say you have dates in A2:A100 and corresponding values in B2:B100.
1) To sum the values for a specific date:
Enter that date in D2.
In E2, enter the formula
=SUMIFS(B2:B100, A2:A100, D2)
2) To sum values for a range of dates:
Enter the first date to include in D2 and the last date in E2.
In F2, enter the formula
=SUMIFS(B2:B100, A2:A100, ">="&D2, A2:A100, "<="&E2)
3) To sum values for a specific day of the week:
Enter the number of the weekday in D2, with 1=Sunday, 2=Monday, etc.
In E2, enter the formula
=SUMPRODUCT(B2:B100,--(WEEKDAY(A2:A100)=D2))
4) To sum values for a a range of days of the week:
Enter the number of the first weekday to include in D2, and that of the last weekday in E2, with 1=Sunday, 2=Monday, etc.
In F2, enter the formula
=SUMPRODUCT(B2:B100,(WEEKDAY(A2:A100)>=D2)*(WEEKDAY(A2:A100)<=E2))