I am working on a time sheet that had one other/code column. In the debit
column, there was an if function( if(I7="c",h7,"") So if the code =C, it
automatically went over to the debit column. We have added an additional
column because sometimes employees might take 2 hrs c (comp) and 2 hrs v
(vacation)
but, I only want it to add i & k if they both =c, or return the value for i
or k if one =c.
looks like this:
h i j k
other- code- other- code - Debit
2 c 3 v 2

2 v 1 c 1
Some of the formulas I have tried are;

=IF(AND(OR(I9="c",K9="c")),(H9+J9),"")
=IF(AND(I8="c",K8="c"),(H8+J8),)

It will make both columns add, regardless of what the code is.
does anybody have any ideas?
thanks for your help!
Sheila