This formula in Totals!B14 can be copied down and across
=SUMPRODUCT(--(INFORMATION!$B$6:$B$23=B$13), --(INFORMATION!$C$6:$C$23=$A14), INFORMATION!$G$6:$G$23)
You were not referring to Information with the last argument (and were referring to J instead of G) and had a different number of rows. The way this is set up, each argument must have the same number of rows. I also replaced the hard values of UA and Meeting rooms with cell references. Questions?
Bookmarks