Spreadsheet: 62959d1263938814-embedding-if-statement-into-sumproduct-example
Sheet: Summary Day Count

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Rating | Price Target
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Upgraded | Increased |  |  |  |  | Day Count
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Downgraded | Decreased |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Change | Unchanged
 |  | Rating | Price Target |  | Rating | Price Target |  | Rating | Price Target |  | Rating | Price Target |  |  | Rating | Price Target |  | Rating | Price Target |  | Rating | Price Target |  | Rating | Price Target
 |  | Upgraded |  |  | Downgraded |  |  |  | Increased |  |  | Decreased |  |  | Upgraded |  |  | Downgraded |  |  |  | Increased |  |  | Decreased
 |  | Outperform/Underperform ETF | Total # |  | Outperform/Underperform ETF | Total # |  | Outperform/Underperform ETF | Total # |  | Outperform/Underperform ETF | Total # |  |  | Outperform/Under ETF | Total # |  | Outperform/Under ETF | Total # |  | Outperform/Under ETF | Total # |  | Outperform/Under ETF | Total #
 | ii1-2x | 0 | 0 |  | 0 | 0 |  | 0 | 2 |  | 0 | 0 |  | ii1-2x
 | ii1-3x | 0 | 0 |  | 0 | 0 |  | 0 | 1 |  | 0 | 0 |  | ii1-3x
 | ii1-4x | 0 | 0 |  | 0 | 0 |  | 0 | 1 |  | 0 | 1 |  | ii1-4x
 | ii1-5x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | ii1-5x
 | ii1-6x | 0 | 0 |  | 0 | 0 |  | 0 | 1 |  | 0 | 1 |  | ii1-6x
 | ii1-7x | 0 | 0 |  | 0 | 0 |  | 0 | 5 |  | 0 | 0 |  | ii1-7x
 | ii1-8x | 0.1494011835992932 | 2 |  | 0 | 0 |  | 0.0720598957870213 | 1 |  | 0 | 0 |  | ii1-8x | 0.07470059179964658 | 2 |  |  |  |  | 0.0720598957870213 | 1
 | ii1-9x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | ii1-9x
 | ii1-10x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | ii1-10x
 | Total | 0.1494011835992932 | 2 |  | 0 | 0 |  | 0.0720598957870213 | 11 |  | 0 | 2 |  | Total Average | 0.07470059179964658 |  |  | #N/A |  |  | 0.006550899617001935 |  |  | 0
 |  | Rating | Price Target |  | Rating | Price Target |  | Rating | Price Target |  |  |  |  |  | Rating | Price Target |  | Rating | Price Target |  | Rating | Price Target
 |  | Upgraded | Increased |  | Upgraded | Unchanged |  | Upgraded | Decreased |  |  |  |  |  | Upgraded | Increased |  | Upgraded | Unchanged |  | Upgraded | Decreased
 |  | Outperform/Underperform ETF | Total # |  | Outperform/Underperform ETF | Total # |  | Outperform/Underperform ETF | Total # |  |  |  |  |  | Outperform/Under ETF | Total # |  | Outperform/Under ETF | Total # |  | Outperform/Under ETF | Total #
 | ii1-2x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-2x
 | ii1-3x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-3x
 | ii1-4x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-4x
 | ii1-5x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-5x
 | ii1-6x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-6x
 | ii1-7x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-7x
 | ii1-8x | 0.0720598957870213 | 1 |  | 0.07734128781227186 | 1 |  | 0 | 0 |  |  |  |  | ii1-8x | 0.0720598957870213 | 1 |  | 0.07734128781227186 | 1
 | ii1-9x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-9x
 | ii1-10x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-10x
 | Total | 0.0720598957870213 | 1 |  | 0.07734128781227186 | 1 |  | 0 | 0 |  |  |  |  | Total Average | 0.0720598957870213 |  |  | 0.07734128781227186 |  |  | #N/A
 |  | Rating | Price Target |  | Rating | Price Target |  | Rating | Price Target |  |  |  |  |  | Rating | Price Target |  | Rating | Price Target |  | Rating | Price Target
 |  | Downgraded | Decreased |  | Downgraded | Unchanged |  | Downgraded | Increased |  |  |  |  |  | Downgraded | Decreased |  | Downgraded | Unchanged |  | Downgraded | Increased
 |  | Outperform/Underperform ETF | Total # |  | Outperform/Underperform ETF | Total # |  | Outperform/Underperform ETF | Total # |  |  |  |  |  | Outperform/Under ETF | Total # |  | Outperform/Under ETF | Total # |  | Outperform/Under ETF | Total #
 | ii1-2x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-2x
 | ii1-3x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-3x
 | ii1-4x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-4x
 | ii1-5x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-5x
 | ii1-6x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-6x
 | ii1-7x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-7x
 | ii1-8x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-8x
 | ii1-9x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-9x
 | ii1-10x | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | ii1-10x
 | Total | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | Total Average | #N/A |  |  | #N/A |  |  | #N/A
 |  | Rating | Price Target |  | Rating | Price Target |  |  |  |  |  |  |  |  | Rating | Price Target |  | Rating | Price Target
 |  | No Change | Increased |  | No Change | Decreased |  |  |  |  |  |  |  |  | No Change | Increased |  | No Change | Decreased
 |  | Outperform/Underperform ETF | Total # |  | Outperform/Underperform ETF | Total # |  |  |  |  |  |  |  |  | Outperform/Under ETF | Total # |  | Outperform/Under ETF | Total #
 | ii1-2x | 0 | 2 |  | 0 | 0 |  |  |  |  |  |  |  | ii1-2x
 | ii1-3x | 0 | 1 |  | 0 | 0 |  |  |  |  |  |  |  | ii1-3x
 | ii1-4x | 0 | 1 |  | 0 | 1 |  |  |  |  |  |  |  | ii1-4x
 | ii1-5x | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  | ii1-5x
 | ii1-6x | 0 | 1 |  | 0 | 1 |  |  |  |  |  |  |  | ii1-6x
 | ii1-7x | 0 | 5 |  | 0 | 0 |  |  |  |  |  |  |  | ii1-7x
 | ii1-8x | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  | ii1-8x
 | ii1-9x | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  | ii1-9x
 | ii1-10x | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  | ii1-10x
 | Total | 0 | 10 |  | 0 | 2 |  |  |  |  |  |  |  | Total Average | 0 |  |  | 0