A
alexm999
I'm going through a brain freeze and need assistance.
I have a worksheet with 5 columns (A,B,C,D,E)
Column A has the following info: 101, 102, 103, 104 & 105.
Column C are dates in the following format: 2004.10.26
Column D is the dollar amount: $500 or $200 or whatever
Column E is advertising: TV, Radio, Flyer
I'd like to sort all the column A that have the code 101 in it and the
add up the Column D that have the TV advertising in column E
Help!
I have a worksheet with 5 columns (A,B,C,D,E)
Column A has the following info: 101, 102, 103, 104 & 105.
Column C are dates in the following format: 2004.10.26
Column D is the dollar amount: $500 or $200 or whatever
Column E is advertising: TV, Radio, Flyer
I'd like to sort all the column A that have the code 101 in it and the
add up the Column D that have the TV advertising in column E
Help!