Sum(if ... multiple conditions ... Interpretation?

[Ken]

Excel 2000 ... I attempted to write the following array
formula free-hand & failed ... Consequently, I used
Conditional Sum Wizard to build formula for me.

Above said ... Can one of you Excel Magicians interpret
(in plain English) how end of this formula works?

=SUM(IF($M$2:$M$12000=$BG2,IF($T$2:$T$12000=0,1,0),0))

,1,0),0))

What do last 3 positions & characters stand for? I am
pretty certain the 1st 1,0) is part of 2nd IF Function,
but have no idea how formula is working.

Thanks ... Kha

 

[Don Guillett]

Look in HELP for sumif instead.
This if you want to sum t for cells in m that match bg2

=sumif($M$2:$M$12000,$BG2,$T$2:$T$12000)

 

[Frank Kabel]

Hi
the formula returns 1 if both conditionas are met or 0 if not both
conditionas are met. So your right. 1 is the tRUE part of the second IF
formula and '0' the FALSE part.

You may take a look at the following site for an alternative approach using
sUMPRODUCT:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Ken]

Frank ... How about the last 0?

Is this telling the SUM Function 0 Decimal places?

Thanks ...

 

[Frank Kabel]

Hi
no
this is the result if the first condition is not met (the FALSE part of the
first IF statement)

 

[Ken]

Don ...

I do not know how to use SUMIF for multiple conditions?
So have been using ... SUM(IF( ..... instead.

Or at least attempting to.

Thanks ... Kha

 

[Ian Ripsher]

Don ...

I do not know how to use SUMIF for multiple conditions?
So have been using ... SUM(IF( ..... instead.

Or at least attempting to.

Thanks ... Kha

Try SUMPRODUCT. See: http://www.xldynamic.com/source/xld.SUMPRODUCT.html