Excel: How to sum using two or more if a - TechRepublic
General discussion
November 9, 2001 at 01:31 AM
dbaker

Excel: How to sum using two or more if a

by dbaker . Updated 24 years, 7 months ago

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??

This discussion is locked

All Comments