column A contains the date

this is the formula i have in column H

=SUMPRODUCT($B$7:$B$91,--(JULIAN>0),--(JULIAN<$AJ7+1))

Now i have to break it down by vacation or sick time

So in colum D I am going to put either a V or S so if it is V it will use the above formula and in a new column i am going to make for S

I guesss what i need is an IF Statement to add to the above formula and the new column for Sick time

Hope fully this example will show what i need

A B D H K

8/5 8.00 V 8.00 0.00

8/25 8.00 S 0.00 8.00

9/1 8.00 V 16.00 0.00

hope you understand what I am trying to do

Thanks in advance for any help