Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
too many arguments in formula. alternative?
Hi, I'm making a planning for a project, with about 60 tasks (rows) and 20
weeks. For each task I list who's responsible, by initial. Each cell (60 times 20) contains the number of hours the person will spend on that task in that week. Most tasks are running parallel (i.e. one person does many tasks in any given week). On a second sheet I wish to add them all up to show the workload per person per week (for all the tasks). I would like to use a conditional formula based on the initials, as follows IF(Initial=true, hours, 0) and add them up per week for all tasks. Unfortunately, this sum contains too many arguments (60 tasks and more may be added) or is too long. The (working) alternative is that I manually select all cells that apply to person X and add them up with a simple sum, but this is not very adaptable. Is there a better way of doing this (possibly matrix based)? Thanks very much in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
too many arguments in formula. alternative?
Why don't you use SUMIF?
Regards, Stefi €˛jansaver€¯ ezt Ć*rta: Hi, I'm making a planning for a project, with about 60 tasks (rows) and 20 weeks. For each task I list who's responsible, by initial. Each cell (60 times 20) contains the number of hours the person will spend on that task in that week. Most tasks are running parallel (i.e. one person does many tasks in any given week). On a second sheet I wish to add them all up to show the workload per person per week (for all the tasks). I would like to use a conditional formula based on the initials, as follows IF(Initial=true, hours, 0) and add them up per week for all tasks. Unfortunately, this sum contains too many arguments (60 tasks and more may be added) or is too long. The (working) alternative is that I manually select all cells that apply to person X and add them up with a simple sum, but this is not very adaptable. Is there a better way of doing this (possibly matrix based)? Thanks very much in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
too many arguments in formula. alternative?
Thank you very much. I wasn't aware of that formula..
"Stefi" wrote: Why don't you use SUMIF? Regards, Stefi €˛jansaver€¯ ezt Ć*rta: Hi, I'm making a planning for a project, with about 60 tasks (rows) and 20 weeks. For each task I list who's responsible, by initial. Each cell (60 times 20) contains the number of hours the person will spend on that task in that week. Most tasks are running parallel (i.e. one person does many tasks in any given week). On a second sheet I wish to add them all up to show the workload per person per week (for all the tasks). I would like to use a conditional formula based on the initials, as follows IF(Initial=true, hours, 0) and add them up per week for all tasks. Unfortunately, this sum contains too many arguments (60 tasks and more may be added) or is too long. The (working) alternative is that I manually select all cells that apply to person X and add them up with a simple sum, but this is not very adaptable. Is there a better way of doing this (possibly matrix based)? Thanks very much in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
too many arguments in formula. alternative?
It's not clear exactly how you have your data laid out, but have a look at
the SUMIF function. This might be what you need. -- Ian -- "jansaver" wrote in message ... Hi, I'm making a planning for a project, with about 60 tasks (rows) and 20 weeks. For each task I list who's responsible, by initial. Each cell (60 times 20) contains the number of hours the person will spend on that task in that week. Most tasks are running parallel (i.e. one person does many tasks in any given week). On a second sheet I wish to add them all up to show the workload per person per week (for all the tasks). I would like to use a conditional formula based on the initials, as follows IF(Initial=true, hours, 0) and add them up per week for all tasks. Unfortunately, this sum contains too many arguments (60 tasks and more may be added) or is too long. The (working) alternative is that I manually select all cells that apply to person X and add them up with a simple sum, but this is not very adaptable. Is there a better way of doing this (possibly matrix based)? Thanks very much in advance. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
too many arguments in formula. alternative?
You are welcome! Thanks for the feedback!
Stefi €˛jansaver€¯ ezt Ć*rta: Thank you very much. I wasn't aware of that formula.. "Stefi" wrote: Why don't you use SUMIF? Regards, Stefi €˛jansaver€¯ ezt Ć*rta: Hi, I'm making a planning for a project, with about 60 tasks (rows) and 20 weeks. For each task I list who's responsible, by initial. Each cell (60 times 20) contains the number of hours the person will spend on that task in that week. Most tasks are running parallel (i.e. one person does many tasks in any given week). On a second sheet I wish to add them all up to show the workload per person per week (for all the tasks). I would like to use a conditional formula based on the initials, as follows IF(Initial=true, hours, 0) and add them up per week for all tasks. Unfortunately, this sum contains too many arguments (60 tasks and more may be added) or is too long. The (working) alternative is that I manually select all cells that apply to person X and add them up with a simple sum, but this is not very adaptable. Is there a better way of doing this (possibly matrix based)? Thanks very much in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Locking portions of a formula | Excel Worksheet Functions | |||
assign formula to another cell | Excel Worksheet Functions | |||
Help crating a formula with various arguments | Excel Worksheet Functions | |||
how do I set up a formula using number ranges as the arguments | New Users to Excel |