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.