Ask Your Question
2

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

asked 2018-11-25 01:15:42 +0200

downiepaul gravatar image

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.

edit retag flag offensive close merge delete

Comments

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

ebot gravatar imageebot ( 2018-11-25 09:44:38 +0200 )edit

@ebot, OQ does not have enough "karma" to upload a file.

BigRAl gravatar imageBigRAl ( 2018-11-26 12:56:00 +0200 )edit
1

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

ebot gravatar imageebot ( 2018-11-26 13:18:51 +0200 )edit

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

BigRAl gravatar imageBigRAl ( 2018-11-26 13:22:39 +0200 )edit

That would be flattered.

ebot gravatar imageebot ( 2018-11-26 13:30:54 +0200 )edit

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

EasyTrieve gravatar imageEasyTrieve ( 2018-11-27 17:49:52 +0200 )edit

@downiepaul, please improve your question.

EasyTrieve gravatar imageEasyTrieve ( 2018-11-27 17:50:20 +0200 )edit

Simple solution guys, just vote the Q up by one

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

BigRAl gravatar imageBigRAl ( 2018-11-28 14:02:29 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-11-26 01:26:23 +0200

m.a.riosv gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-11-25 01:15:42 +0200

Seen: 38 times

Last updated: Nov 26 '18