Please help with Excel formula

[Pat1009]

This is half of a formula I have.....

=20-SUM(COUNTIFS('All Worker Time Off'!$C:$C,"john smith*",'All Worker Time Off'!$D:$D,”Time Off Request))

I need it to start at 20 and minus 1 for every time it finds, in the "All Worker Time Off" sheet, john smith in column $C:$C and also finds
"Time off Request" in column $D:$D

The way it is now, it just outputs 20, but there is only 1 entry that has john smith and time off request, so it should output 19

 

[Pat1009]

I realized my mistake, after all, it should have been this.....

=20-SUM(COUNTIFS('All Worker Time Off'!$C:$C,"john smith*",'All Worker Time Off'!$D:$D,"Time Off Request"))