Conditional sum

G

gb_S49

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
 
B

bj

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top