Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for several arguments results in 1 cell
I will try my best to describe what I am trying to do he
I have 3 tabs, tab 1 - Summary, tab 2 - Room Data, tab 3 - data Tab 1 I have a cell I want to show the result of several things that occur on Room Data tab. I want to total like area types, then check it against if it should be totaled as beds, or rooms. If a bed then it will look in a range for what a bed has for scfm usage then find it's simultanious use factor and multiply it against how many beds there are and do this for each different type of area. I am thinking I need to just create a cell to calculate each type of conditions I am looking for, then total all the O2scfm and have the cell on the summary tab look at that cell. If I try to create formula or even a macro, this could get lengthy. Any ideas? it sounds like maybe a macro would work better in this case. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula results to be copied into a different cell | New Users to Excel | |||
Am I able to 'fix' the results of a formula into a cell? | Excel Discussion (Misc queries) | |||
How to save results of a formula in an other cell | Excel Discussion (Misc queries) | |||
no formula results in cell | Excel Worksheet Functions | |||
Some formula results will not show up in the cell | Excel Worksheet Functions |