$205.$ In total, how many dollars have been earned $($total sales$)$ in TX$?$

Use the Vlookup to add "state" to colmn N

Use the Vlookup to add "Price" to colmn O

Calculate a column called earned

To do so multiply $($Sales Qty $*$ Price$)$