One cell formula tabulating/referencing a table

Hi gang!  Can you all help me consolidate a formula?  I'm counting instances from one column of data on Tab-1, then grabbing a referenced power value from Tab-2 but sweeping through all component opt...