I have a spreadsheet that contains two columns that I need evaluated before producing the sum (population). Here are the details:
Criteria should read: If rows (1 - 19) in column C contains "Yes" and NOT(If rows (1 - 19) in column A contain "Digital Terminal Adapter" or "Cable Card" ) then sum all of matching criteria in Column D (population).
I have attached a file to better illustrate what I am doing. Basically if yes in column C, but exclude the 2 criteria in column A.