I've got a timesheet built, but it does something slightly unique that
I haven't been able to find an example of or that someone has already
asked this question, so here it goes.

First, my worksheet has.
Column A
Date
Column B
Start time
Column C
End time
Column D
Code (R-regular time, C- comp time, V-vacation, etc)
Column E
Hours (C2-B2)*24
Column F
Comp Time Earned =IF(E2>8,SUM(E2-8),0)

What I need to do is to have the total of Comp time earned be deducted
if the Code in Column D is "C". I've tried with
=IF(D2="C",SUM(F33-E2),0) and it seems to work okay looking at a
single cell, but I need to have it look at the whole column and add in
a cell for comp time used.
Does what I have so far seem like the best way to do it?
What should I use to look at the entire column?
Better question, does all of this make sense?

Thanks in advance.
Brian