Uploaded June 2017 | Updated September 2026, 50 minutes ago

---

excelxor.com
00:00 Challenge explanation
00:28 Winning formula
------detailed explanation------
01:24 Step 1 Countif range "A1:H8" is CHESS BOARD
01:35 Step 2 COLOR & PIECES: {"B","W"}&{"P";"N";"B";"R";"Q"}
02:05 Step 3 Create all pieces {"BP","WP";"BN","WN";"BB","WB";"BR","WR";"BQ","WQ"}
03:06 Step 4 CHESS PIECE COUNT {5,5;1,1;2,1;1,1;1,1}
03:42 Step 5 {-5,5;-1,1;-2,1;-1,1;-1,1} - = BLACK, +=WHITE
04:12 Step 6 MULTIPLY PIECE COUNT BY PIECE VALUE {1;3;3;5;9}
04:54 Step 7 {-5,5;-3,3;-6,3;-5,5;-9,9} - = BLACK, +=WHITE
05:00 Step 8 Wrap it with SUM function.
05:08 Changing chess pieces updates formula

Challenge Post: excelxor.com/2014/10/15/shortest-formula-challenge-1-material-gains

Solution Post: excelxor.com/2014/10/22/shortest-formula-challenge-1-results-and-discussion

My Post: myspreadsheetlab.com/video-00162-excel-formula-calculates-value-of-chess-pieces