I am really stumped... If you look at the attachment, what I'm trying to do is count the "Number of Visible Products" in column C only IF there is an x in "Converted" column A. I would like the sum of those converted products in C2. Basically, I will be going into this spreadsheet to put an x in column A when new vendors are converted, but I don't want to keep adding the associated number in column C. Is there an easy way where it automatically looks up the vendors with "x" and the number of products?
Thanks!
Bookmarks