formula for several arguments results in 1 cell

[John Gregory]

I will try my best to describe what I am trying to do here:
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.

 

[Dan DeHaven]

John, I don't think you'd need a macro. At the most maybe just severa
cells that are multiple "if" statements that look at other summar
calculation cells.

My first question is if you're using Excel 2007? Because with 2007 yo
can nest 64 "If" statements as well as use "SUMIFS" and what you'v
described should all be possible with some effort and testing.

If you're using pre 2007 there are still ways to make it happen, you'l
just need to use more cells to separate the possibilities. But then yo
can sum the summary cells for one all encompassing result if that i
what you need.

My suggestion to you is to attach a sample of the file with all th
different "types" of data that you need the formula to make calculation
on and list out the requirements of the formula as clearly as you can
can build a few of the needed formulas for you and you can complete th
rest based on those examples.

Dan