Conditional sum

[Guest]

I would normally do a nested if staement to calculate this but it only works
on summing columns & not rows.
Does anyone now how I can over come this.
I need to summarise that Johns Holiday hours = 20.6 hours. (ie if hol then
hours per )?
Does this make sense?

Hours 4.0 8.3 8.3 8.3
Fri Sat Sun Mon Tue Wed
NAME DATE 01 02 03 04 05 06
John O/time 0.5 0.5
Attend HOL HOL HOL
Mary O/time 1.5 1.5 1.5
Attend
Steve O/time 2 2 2 2
Attend PMH

 

[Guest]

give a samole of the nested equation you use in columns
I do not know what you want to do in the table.