Hi,

The best solution is always a matter of some issue - for example, if you
arre using 2007 your best solution might be

=SUMIFS(C1:C99,A1:A99,"E",B1:B99,15)

where you want to sum column C if A is E and B is 15.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Rasoul Khoshravan" wrote:

On Feb 14, 10:21 pm, Dave wrote:
I have a spreadsheet where all entries in Col A are either "E" or "S". Col B
has 10 different possible entries. I need a formula to 1st, select every row
that is an "E", then 2nd, out of that, select only the rows that match a
criteria for Col B's possibilites and 3rd, using the rows that the 2nd step
selected, add all of the values in Col C and generate a total.
I have various modifications of IF and SUMIF and cannot get anything to work.
Any help would be greatly appreciated.

First post on a new thread as you might be ignored sending your
question on others.
Second the best function to answer multiple conditioning is sumproduct

Sumproduct(--(A1:A10="E"),--(B1:B10="put your criteria for column B
here",C1:C10)

For more info on sumproduct, go to
http://www.xldynamic.com/source/xld.SUMPRODUCT.html