[Solved] Typos in "[Tutorial] The SUMPRODUCT function"

[cwolan]

@MrProgrammer

I presume there are still at least two typos in your tutorial

X25: Count text cells which exactly match a string, say "ee". For string "ee", a cell with "EE" is not counted and a cell with "spreadsheet" is not counted.
=SUMPRODUCT(EXACT(X2:XΩ;"ee")))

In formula: one closing parenthesis too much.

X30: Sum numbers where the values in two columns are the same/different, not possible with SUMIF/SUMIFS
=SUMPRODUCT((S2:SΩ;X2:XΩ=Y2:YΩ) — Sum column S where X value equals the Y value

In formula: one opening parenthesis too much.

[MrProgrammer]

Thank you, cwolan, for your assistance in improving the tutorial. And I know that someone is reading it. I hope it helpful for people. The difficulties you discovered have been corrected.

[cwolan]

The pleasure is all mine.
Thank you for your informative and cunning examples of the versatility of SUMPRODUCT.

My bad. I forgot to point out the third typo (though you may find it nitpicking):

X37: Bitwise operations for 48-bit unsigned numbers
First use Insert → Names → Define → Name → Two047 → AssignedTo → 2^(ROW($A$1:$A$48)-ROW($A$1)) → OK

AssignedTo ⟶ Assigned To