Apache OpenOffice Community Forum

@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.

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.

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