I need to do a count based on multiple columns in a separate spreadsheet. Ideas?

I am collecting statistics on one spreadsheet, based on data on another spreadsheet. The statistics will be the counts of items in multiple columns, for instance, if Column A has “x”, and Column Z has “x”, then what is the count. Sometimes, the counts is from three or more columns.

Show an example. Anonymise the file and upload it here. To upload, edit your file.

@Hrbrgr, OQ does not have enough “karma” to upload a file.

@BigRAl Thanks for information. ask.libreoffice is in my opinion a horrible system.

Not the world’s most user-friendly, is it?

That would be flattered.

@Hrbrgr & @BigRAl, Simple solution guys, just vote the Q up by one, and then he or she can upload that demo file.

@downiepaul, please improve your question.

Simple solution guys, just vote the Q up by one

Thanks for the tip, @EasyTrieve, I’m still a newbie contributor.

A couple or ways to count with several conditions:

=COUNTIFS(Range1; Criterion1 [; Range2; Criterion2 [; ...]])
Help COUNTFIS

=SUMPRODUCT(Range1=Condition1;Range2=Condition2;Range3=Condition3;....)
Help SUMPRODUCT