Here’s what I am trying to do: (1) I want to look at column A in the file and find all “1”s, (2) then as I find each “1”, I want the system to look for a “A” in column B. If both conditions are met, then sum column C. I don’t want to use filters because the results need to go on a separate worksheet. Using filters and subtotals in filters will only give me answers on the page that I have the filters. Any ideas??