| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional sum
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional sum
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Sum | Excel Worksheet Functions | |||
| Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
| Conditional Sum | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
| Conditional Value | Excel Discussion (Misc queries) | |||
Hybrid Mode
