Formula for Summary field - Pull multiple items from cell

gwilkinson

I have a group of summary fields I am trying to implement from a sheet. I have successfully done this for all of my summaries but one.

I have this working great…

=SUMIF([Bldg-Room]:[Bldg-Room], CONTAINS("MRB", @cell ), [Census Master]:[Census Master])

I want to SUM the columns that contain KCRB and RLSB. I have tried some AND as well as some simple commas to separate the contains calls. But I am clearly doing it wrong and the formula builder is failing me.

=SUMIF([Bldg-Room]:[Bldg-Room], CONTAINS("KCRB", @cell ) OR CONTAINS("RLSB", @cell ), [Census Master]:[Census Master])

This is what the formula maker keeps spitting at me…

gwilkinson

As usual, as soon as I post the question I find the answer. :)

=SUMIFS([Census Master]:[Census Master], [Bldg-Room]:[Bldg-Room], CONTAINS("KCRB", @cell ) = true) + SUMIFS([Census Master]:[Census Master], [Bldg-Room]:[Bldg-Room], CONTAINS("RLSB", @cell ) = true)