You can use a non-array entered formula to do this. Just use a big enough
range that you know you will never exceed:

All on one line

=SUMPROUCT(--(A2:A1000="Hospital A"),
--(B2:B1000="ICU"),--(F2:F1000=1),H2:H1000)

Or, you can use dynamic ranges:

http://contextures.com/xlNames01.html#Dynamic

--
Biff
Microsoft Excel MVP


"Peige414" wrote in message
...
I'm trying to apply the concept of conditional summing to a dataset that
continually changes. I understand how to use conditional sum arrays when
specifiying a range, but since the dataset is always changing, I don't
always
know what the new range will be. I don't want to waste time going through
all of my formulas fixing the ranges.

Right now I have something like this:
=SUM(IF($A$2:$A$150="Hospital
A",IF($B$2:$B$150="ICU",IF($F$2:$F$150=1,$H$2:$H$1 50,0),0),0))

Anyone know how I can phenagle things so that I can get excel to think
this:
=SUM(IF($A:$A="Hospital A",IF($B:$B="ICU",IF($F:$F=1,$H:$H,0),0),0))

Any help would be greatly appreciated.