IF, AND for different Columns

[texansgal]

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

 

[Fred Smith]

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]

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?

 

[David Biddulph]

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"))