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
-----Original Message-----
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)
--
Don Guillett
SalesAid Software
"Ken" wrote in
message
...
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
.
|