IF, AND for different Columns
in [Functions]
|
Prev: Macros running with Validation Rules
Next: Group information from several worksheets into one worksheet
From: texansgal on 8 Mar 2010 17:02 I have a worksheet for a meeting that I am trying to get to where I can use the formula's and it will calculate as soon as the data is pasted from another report. I need the following: Column E will have the following options: BUY STK BUY/STK STK/BUY FRT Column F will have the following options: CAWPHY CAWPB CFWPHY CFWPB FRT (plus way more to list) The total of each Row is listed in Column J So, if Column E has "BUY" and Column F has "CAWPHY", I want the sum which is in Column J to be in cell E39. If Column E has "STK" and Column F has "CAWPHY", I want the sum which is in Column J to be in cell E40...and so on. There might 10 rows with the same in Column's E and F with the total of that line in J that I need listed in the totals section at the bottom. Can someone PLEASE HELP ME? Thank you, Vanessa
From: Fred Smith on 8 Mar 2010 18:49
First, you don't want IF or AND. Second, the function you want is SUMPRODUCT. However, by far you most effective and simplest solution is a Pivot Table. Read all about them here: http://www.cpearson.com/excel/pivots.htm Regards, Fred "texansgal" <texansgal(a)discussions.microsoft.com> wrote in message news:05A4E6F6-C565-4828-B262-7AAD00E4316D(a)microsoft.com... >I have a worksheet for a meeting that I am trying to get to where I can use > the formula's and it will calculate as soon as the data is pasted from > another report. > > I need the following: > > Column E will have the following options: > BUY > STK > BUY/STK > STK/BUY > FRT > > > Column F will have the following options: > CAWPHY > CAWPB > CFWPHY > CFWPB > FRT > (plus way more to list) > > The total of each Row is listed in Column J > > So, if Column E has "BUY" and Column F has "CAWPHY", I want the sum which > is > in Column J to be in cell E39. If Column E has "STK" and Column F has > "CAWPHY", I want the sum which is in Column J to be in cell E40...and so > on. > > There might 10 rows with the same in Column's E and F with the total of > that > line in J that I need listed in the totals section at the bottom. > > Can someone PLEASE HELP ME? > > Thank you, > Vanessa > > > > > |