Forum Discussion
How to sum horizontally but with date wise match column
Hi Everyone!
Hope you all well, i just want a help that how can we sum horizontally with date range and if the date column is not static, attaching image for more understanding. If i need to get sum of district within the date range 2022-08-24 to 2022-08-29.
Let's say the dates are in F1:DZ1
Enter the start date 2022-08-24 and the end date 2022-08-29 in two separate cells, e.g. EA1 and EB1.
(These are just arbitrary examples).
The formula for the sum in row 2 is
=SUMIFS($F2:$DZ2, $F$1:$DZ$1, ">="&$EA$1, $F$1:$DZ$1, "<="&$EB$1)
This can be filled down.
- Thank you so much
