Select rows w/cells containing given character strings, then sum cell in two other col.
I need a formula that will select rows containing cells w/given character string, then sum values in other cells in the same row. More info: I downloaded info from my broker that contains all activity in my stock account since 2010. If a cell in col. 'A' has a date < 08/25/2015 and cell in col. 'C' contains a given char string and a cell in col. 'F' contains a given string, then sum counts in col. 'I' and sum $$$ in col. 'K'. The IRS will need this info when I sell the stock.
|