Hi I have a list of hours but I only want to sum the hours that are less then 40 hours only. So see example below. The total should be 48 hours. Can someone please help me figure this out. Thanks.
........A
1......40
2......40
3......32
4......16
5......40
total:48
........A
1......40
2......40
3......32
4......16
5......40
total:48