Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Multiple X-Axis Values | Charts and Charting in Excel | |||
How do I avoid saving multiple Excel/Wordfiles for versioning purp | Excel Discussion (Misc queries) |