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

  • Thread starter Thread starter Ken
  • Start date Start date
K

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
 
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 ... How about the last 0?

Is this telling the SUM Function 0 Decimal places?

Thanks ...
 
Hi
no
this is the result if the first condition is not met (the FALSE part of the
first IF statement)
 
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
 
Back
Top