Jan 03 2022 04:39 PM
Hi All,
Jan 03 2022 10:57 PM - edited Jan 04 2022 10:59 PM
Solution@forbesy71 I would use SUMIFS as demonstrated in the attached file. By the way, better to get rid of merged cells in the header of LIFTS and note that the CAR7 sheet had December dates where the other two were for November. I changed the first one to November.
Jan 04 2022 10:41 PM
@Riny_van_Eekelen Thank you Riny, worked a treat. Greatly Appreicated.
Jan 03 2022 10:57 PM - edited Jan 04 2022 10:59 PM
Solution@forbesy71 I would use SUMIFS as demonstrated in the attached file. By the way, better to get rid of merged cells in the header of LIFTS and note that the CAR7 sheet had December dates where the other two were for November. I changed the first one to November.