Spreadsheet: 697070d1601139164-sum-if-function-returning-0-similar-sumifs-working-fine-portfolio-tracker
Sheet: Equitiy ETF Breakdowns

 | Ticker | Value (USD) |  |  | Ticker | Value USD |  |  | Ticker | Value USD |  |  | Ticker | Value USD |  |  | Ticker | Value USD |  |  | Ticker | Value USD |  |  | Ticker |  | Value USD |  |  |  |  | ETF Portfolio | Value USD
 | SPY |  |  |  | QQQ |  |  |  | VTV |  |  |  | VO |  |  |  | VWO |  |  |  | EQL.TO |  |  |  | XLI
 | #[NAME]! |  |  |  | #[NAME]! |  |  |  | #[NAME]! |  |  |  | #[NAME]! |  |  |  | #[NAME]! |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | Sector | Percentage | Weighted Value (USD) |  | Sector | Percentage | Weighted Value |  | Sector | Percentage | Weighted Value |  | Sector | Percentage | Weighted Value |  | Sector | Percentage | Weighted Value |  | Sector | Percentage | Weighted Value
 | Basic Materials | 0.0168 |  |  | Communications | 0.204 |  |  | Healthcare | 0.2099 |  |  | Technology | 0.1829 |  |  | Financials | 0.1875 |  |  | Technology | 0.1426
 | Communications | 0.1112 |  |  | Consumer, Cyclical | 0.1578 |  |  | Financials | 0.1828 |  |  | Healthcare | 0.1254 |  |  | Consumer, Cyclical | 0.14 |  |  | Industrials | 0.1322
 | Consumer, Cyclical | 0.11 |  |  | Consumer, Non-Cyclical | 0.0529 |  |  | Consumer, Non-Cyclical | 0.1251 |  |  | Industrials | 0.1159 |  |  | Communications | 0.1337 |  |  | Financials | 0.1233
 | Consumer, Non-Cyclical | 0.0698 |  |  | ETF Cash Component | 0.0012 |  |  | Industrials | 0.0914 |  |  | Consumer, Cyclical | 0.1071 |  |  | Technology | 0.1278 |  |  | Healthcare | 0.1223
 | Energy | 0.0258 |  |  | Healthcare | 0.0759 |  |  | Technology | 0.0842 |  |  | Financials | 0.1023 |  |  | Other | 0.0852 |  |  | Consumer, Cyclical | 0.1151
 | ETF Cash Component | 0.0011 |  |  | Industrials | 0.021 |  |  | Communications | 0.0709 |  |  | Real Estate | 0.0811 |  |  | Basic Materials | 0.0713 |  |  | Consumer, Non-Cyclical | 0.0638
 | Financials | 0.0954 |  |  | Other | 0.0237 |  |  | Utilities | 0.0672 |  |  | Other | 0.0765 |  |  | Energy | 0.0563 |  |  | Real Estate | 0.0575
 | Healthcare | 0.1401 |  |  | Technology | 0.4564 |  |  | Energy | 0.0503 |  |  | Utilities | 0.0588 |  |  | Consumer, Non-Cyclical | 0.0556 |  |  | Utilities | 0.0552
 | Industrials | 0.0691 |  |  | Utilities | 0.0071 |  |  | Other | 0.0418 |  |  | Basic Materials | 0.0505 |  |  | Industrials | 0.047 |  |  | Other | 0.0515
 | Other | 0.0332 |  |  |  |  |  |  | Consumer, Cyclical | 0.0369 |  |  | Communications | 0.0375 |  |  | Healthcare | 0.0358 |  |  | Energy | 0.0498
 | Real Estate | 0.027 |  |  |  |  |  |  | Basic Materials | 0.0234 |  |  | Consumer, Non-Cyclical | 0.0364 |  |  | Real Estate | 0.0337 |  |  | Basic Materials | 0.0462
 | Technology | 0.2706 |  |  |  |  |  |  | Real Estate | 0.0158 |  |  | Energy | 0.0256 |  |  | Utilities | 0.0254 |  |  | Communications | 0.0404
 | Utilities | 0.03 |  |  |  |  |  |  | ETF Cash Component | 0.0002 |  |  | ETF Cash Component | 0.0001 |  |  | ETF Cash Component | 0.0005 |  |  | ETF Cash Component | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non-Equity | 0.0004
 | Sector | Percentage | Weighted Value (USD) |  | Sector | Percentage | Weighted Value |  | Sector | Percentage | Weighted Value |  | Sector | Percentage | Weighted Value |  | Sector | Percentage | Weighted Value |  | Sector | Percentage | Weighted Value |  |  |  |  |  |  |  |  | Sector | ETF Portfolio Total Value (USD) | ETF Portfilio %
 | Basic Materials |  |  |  | Basic Materials |  |  |  | Basic Materials |  |  |  | Basic Materials |  |  |  | Basic Materials |  |  |  | Basic Materials |  |  |  |  |  |  |  |  |  |  | Basic Materials
 | Communications |  |  |  | Communications |  |  |  | Communications |  |  |  | Communications |  |  |  | Communications |  |  |  | Communications |  |  |  |  |  |  |  |  |  |  | Communications
 | Consumer, Cyclical |  |  |  | Consumer, Cyclical |  |  |  | Consumer, Cyclical |  |  |  | Consumer, Cyclical |  |  |  | Consumer, Cyclical |  |  |  | Consumer, Cyclical |  |  |  |  |  |  |  |  |  |  | Consumer, Cyclical
 | Consumer, Non-Cyclical |  |  |  | Consumer, Non-Cyclical |  |  |  | Consumer, Non-Cyclical |  |  |  | Consumer, Non-Cyclical |  |  |  | Consumer, Non-Cyclical |  |  |  | Consumer, Non-Cyclical |  |  |  |  |  |  |  |  |  |  | Consumer, Non-Cyclical
 | Energy |  |  |  | Energy |  |  |  | Energy |  |  |  | Energy |  |  |  | Energy |  |  |  | Energy |  |  |  |  |  |  |  |  |  |  | Energy
 | ETF Cash Component |  |  |  | ETF Cash Component |  |  |  | ETF Cash Component |  |  |  | ETF Cash Component |  |  |  | ETF Cash Component |  |  |  | ETF Cash Component |  |  |  |  |  |  |  |  |  |  | ETF Cash Component
 | Financials |  |  |  | Financials |  |  |  | Financials |  |  |  | Financials |  |  |  | Financials |  |  |  | Financials |  |  |  |  |  |  |  |  |  |  | Financials
 | Healthcare |  |  |  | Healthcare |  |  |  | Healthcare |  |  |  | Healthcare |  |  |  | Healthcare |  |  |  | Healthcare |  |  |  |  |  |  |  |  |  |  | Healthcare
 | Industrials |  |  |  | Industrials |  |  |  | Industrials |  |  |  | Industrials |  |  |  | Industrials |  |  |  | Industrials |  |  |  |  |  |  |  |  |  |  | Industrials
 | Other |  |  |  | Other |  |  |  | Other |  |  |  | Other |  |  |  | Other |  |  |  | Other |  |  |  |  |  |  |  |  |  |  | Other
 | Real Estate |  |  |  | Real Estate |  |  |  | Real Estate |  |  |  | Real Estate |  |  |  | Real Estate |  |  |  | Real Estate |  |  |  |  |  |  |  |  |  |  | Real Estate
 | Technology |  |  |  | Technology |  |  |  | Technology |  |  |  | Technology |  |  |  | Technology |  |  |  | Technology |  |  |  |  |  |  |  |  |  |  | Technology
 | Utilities |  |  |  | Utilities |  |  |  | Utilities |  |  |  | Utilities |  |  |  | Utilities |  |  |  | Utilities |  |  |  |  |  |  |  |  |  |  | Utilities
 | Asset | Percentage | Weighted Value (USD) |  | Asset | Percentage
 | Common equity | 0.9989 |  |  | Common equity | 0.9996
 | ETF Cash Component | 0.0011 |  |  | ETF Cash Component | 0.0004
 | Market [NAME] | Percentage | Weighted Value (USD) |  | Market [NAME] | Percentage | Weighted Value (USD)
 | Large cap | 0.9053 |  |  | Large cap | 0.9819
 | Mid cap | 0.0858 |  |  | Mid cap | 0.0173
 | Small cap | 0.0077 |  |  | ETF Cash Component | 0.0004
 | ETF Cash Component | 0.0011 |  |  | Small cap | 0.0004
 | Micro cap | 0.0001
 | Market [NAME] | Percentage | Weighted Value (USD) |  | Market [NAME] | Percentage | Weighted Value (USD) |  | Market [NAME] | Percentage | Weighted Value (USD) |  | Market [NAME] | Percentage | Weighted Value (USD) |  | Market [NAME] | Percentage | Weighted Value (USD) |  | Market [NAME] | Percentage | Weighted Value (USD)
 | Large cap |  |  |  | Large cap |  |  |  | Large cap |  |  |  | Large cap |  |  |  | Large cap |  |  |  | Large cap
 | Mid cap |  |  |  | Mid cap |  |  |  | Mid cap |  |  |  | Mid cap |  |  |  | Mid cap |  |  |  | Mid cap
 | Small cap |  |  |  | Small cap |  |  |  | Small cap |  |  |  | Small cap |  |  |  | Small cap |  |  |  | Small cap
 | ETF Cash Component |  |  |  | ETF Cash Component |  |  |  | ETF Cash Component |  |  |  | ETF Cash Component |  |  |  | ETF Cash Component |  |  |  | ETF Cash Component
 | Micro cap |  |  |  | Micro cap |  |  |  | Micro cap |  |  |  | Micro cap |  |  |  | Micro cap |  |  |  | Micro cap
 | Region | Percentage |  |  | Region | Percentage
 | North America | 0.979 |  |  | North America | 0.9609
 | Europe | 0.0199 |  |  | Europe | 0.0191
 | ETF Cash Component | 0.0011 |  |  | Asia | 0.0134
 |  |  |  |  | Latin America | 0.0047
 |  |  |  |  | Middle East | 0.0016
 |  |  |  |  | ETF Cash Component | 0.0004
 | Region | Percentage |  |  | Region | Percentage
 | United States | 0.9788 |  |  | United States | 0.9609
 | Developed Markets (ex-US) | 0.02 |  |  | Developed Markets (ex-US) | 0.0206
 | ETF Cash Component | 0.0011 |  |  | Emerging Markets | 0.0181
 |  |  |  |  | ETF Cash Component | 0.0004
 | Country | Percentage |  |  | Country | Percentage
 | United States | 0.9788 |  |  | United States | 0.9609
 | United Kingdom | 0.0086 |  |  | China | 0.0134
 | Ireland | 0.0075 |  |  | Germany | 0.0121
 | Germany | 0.0023 |  |  | Netherlands | 0.0058
 | Switzerland | 0.0015 |  |  | Argentina | 0.0047
 | ETF Cash Component | 0.0011 |  |  | Israel | 0.0016
 | Canada | 0.0002 |  |  | United Kingdom | 0.0012
 |  |  |  |  | ETF Cash Component | 0.0004