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

English
, , ,
#1

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.

#2

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

#3

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

#4

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

#5

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

#6

That would be flattered.

#7

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

#8

@downiepaul, please improve your question.

#9

Simple solution guys, just vote the Q up by one

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

#10

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

#11

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.