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.
@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 [; ...]])