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.
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.
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