Forgive me if I can't explain this well...I have 2 columns of data. The first is a binary value (i.e. " x " or " y "). The second has data. I want to move down the second column and sum all values for which the first column of that row contains one of the binary values (for instance "x"). However, I only want to do this for the first 10 rows that have "x" in the first column, and then stop.
I attached a very simple example.
I'm decent with Excel but have been stumped on this one for awhile. Any help is appreciated.
Bookmarks