I'm not sure from your description what it is your are totaling up...
Numbers from another column when Column A and Column B are one of your
indicated combinations? Or the number of times a certain combination
appears? Is there a way you indicate which combination you want to do your
total for?

--
Rick (MVP - Excel)


"texansgal" wrote in message
...
I am looking for a formula where one cell will equal the total of mutiple
cells IF the cells say a different thing.

Example:

Column A has the Description "PUR" or "SK"
Column B has the Description "HY" or "CBN"
Column C has the total of that row (manually entered)

I want the total amount from col C to be all of the "PUR" or "SK" of "HY"
or
"CBN"

So it would be IF cell A has PUR and cell B has HY then the amount in
column
C for those will be totaled here. And so on as there could be 4 different
ways since it could be "PUR" of "HY", "PUR" of "CBN" or "SK" of "HY", "SK"
of
"CBN".

Does this make any sense? It is hard to explain.