I am working in this sample spreadsheet

My first issue: On the sheet New Summary of Leave I would like it to only add Leave Type Vacation and leave out all types Sick. How can I include this condition? Is there any simpler formula I should use?

CodePudding user response：

Try below formula. Add another condition and give criteria Vacation.

=IF(A5<>"",sumifs('Leave responses'!H:H,'Leave responses'!D:D,">="&$E$2,'Leave responses'!D:D,"<="&$G$2,'Leave responses'!D:D,"<=" &now(), 'Leave responses'!C:C,A5,'Leave responses'!F:F,"Vacation"),"")