Forum Discussion
Solved
Count a value in a range which depends on start and end date
Hi Everyone, I need to count how many absent days for each class in a period can be determinded by user. User can choose start date in Cell (AM1) and end date in Cell (AO1). Then in range AO7:AO11...
=SUMPRODUCT(($E$1:$AI$1>=$AM$1)*($E$1:$AI$1<=$AO$1)*($E$2:$AI$7="A")*($D$2:$D$7=AN7))
SUMPRODUCT returns the expected result in my sheet.
=SUMPRODUCT(($E$1:$AI$1>=$AM$1)*($E$1:$AI$1<=$AO$1)*($E$2:$AI$7="A")*($D$2:$D$7=AN7))
SUMPRODUCT returns the expected result in my sheet.
Dear OliverScheurich,
It works! how amazing, simple, clean, clear it is ...
More than appreciated...
Thanks a lot for your very very fast help