ExcelBanter - Conditional sum

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional sum (https://www.excelbanter.com/excel-worksheet-functions/148335-conditional-sum.html)

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

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

"gb_S49" wrote:

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