need some help

[bam12]

I need some help in column B i put how many hours a person uses for PTO (Paid Time Off)
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

 

[bam12]

sorry

Sorry about the confusion, I will try to work it out myself, very hard to explain


Thanks for the help