Thank You, however is not working.

This is my formula: The information is in another sheet (I don't think this should be a problem right?)
In my column B I need the information to be UA and in my column D meeting room and if both conditions are true grab all the values of J and sum it to have a total

=SUMPRODUCT(--('CB DB'!$B$2:$B$500="UA"), --('CB DB'!$D$2:$D$500="meeting room"), $J$2:$J$500)