Apache OpenOffice Community Forum

Hello.
I have a spreadsheet with 'X' in some cells and I want to sum the rows or columns to see how many contain an 'X'.

Lot of stuff posted on SUMIF but I can't get mine to work.

=SUMIF(B2:Q2;"X") returns 0 in all cases.
=SUMIF(B2:Q2;'X') returns 0 in all cases.
=SUMIF(B3:Q2;"=X") returns #NAME?
=SUMIF(B3:Q2;'=X') returns #NAME?
=SUMIF(B2:Q2,'X') returns err:508
=SUMIF(B2:Q2,'X') returns err:508

Help!

Try COUNTIF (B2:Q2;"X") instead. SUMIF works on linked columns, adding only the values in a column that are in a row where another cell meets some condition.

SUMIF is for adding numbers; you want to count the number of occurrences so try COUNTIF.

Thank you! COUNTIF Worked fine.