IF, AND for different Columns
 

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

IF, AND for different Columns
 

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 he
http://www.cpearson.com/excel/pivots.htm

Regards,
Fred

"texansgal" wrote in message
...
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

IF, AND for different Columns
 

My boss doesnt want a pivot table.

Can anyone tell me how this can work?

I need the sum of J3:J29 to be split into different amounts in different
cells going by what E3:E29 and F3:F29 say...


E3=BUY
F3=CAWPHY
J3=2,000.00

D39 named BUY-WPHY needs total of ALL items in Column E=BUY AND F=CAWPHY or
CFWPHY

D40 names STK-WPHY needs total of ALL items in Column E=STK AND F=CAWPHY or
CFWPHY

Does this make better sense?




"Fred Smith" wrote:

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 he
http://www.cpearson.com/excel/pivots.htm

Regards,
Fred

"texansgal" wrote in message
...
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






.

IF, AND for different Columns
 

Why doesn't your boss want a pivot table?

If you want to do it by SUMPRODUCT, try
=SUMPRODUCT(J3:J29,--(E3:E29="BUY"),(F3:F29="CAWPHY")+(F3:F29="CFWPHY") )
=SUMPRODUCT(J3:J29,--(E3:E29="STK"),(F3:F29="CAWPHY")+(F3:F29="CFWPHY") )
--
David Biddulph


"texansgal" wrote in message
...
My boss doesnt want a pivot table.

Can anyone tell me how this can work?

I need the sum of J3:J29 to be split into different amounts in different
cells going by what E3:E29 and F3:F29 say...


E3=BUY
F3=CAWPHY
J3=2,000.00

D39 named BUY-WPHY needs total of ALL items in Column E=BUY AND F=CAWPHY
or
CFWPHY

D40 names STK-WPHY needs total of ALL items in Column E=STK AND F=CAWPHY
or
CFWPHY

Does this make better sense?




"Fred Smith" wrote:

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 he
http://www.cpearson.com/excel/pivots.htm

Regards,
Fred

"texansgal" wrote in message
...
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






.