Ask Your Question

downiepaul's profile - activity

2018-11-27 21:55:07 +0100 marked best answer 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.

2018-11-27 21:44:13 +0100 marked best answer Count with either/or

I'm counting entries from a separate spreadsheet, and have figured out how to do that, e.g., =COUNTIFS(Catalog.E4:E6000,"x",Catalog.G4:G6000,"x",Catalog.M4:M6000,"x").

However, in some instances, there are other entries in the required columns beside "x", and I want to include all entries. So, in the above example, in "Catalog.M4:M6000" I need to include not only "x", but also "D" and "T". How do I adjust the formula to include all those entries?

2018-11-27 21:44:12 +0100 received badge  Scholar (source)
2018-11-27 21:44:01 +0100 answered a question Count with either/or

Thank you for your input. I also discovered that, to include all entries in a column (in this case, "x", "D", "T"), I j

2018-11-27 18:16:18 +0100 received badge  Nice Question (source)
2018-11-27 17:49:54 +0100 received badge  Student (source)
2018-11-27 17:46:52 +0100 received badge  Notable Question (source)
2018-11-27 12:05:48 +0100 received badge  Popular Question (source)
2018-11-27 01:31:37 +0100 asked a question Count with either/or

Count with either/or I'm counting entries from a separate spreadsheet, and have figured out how to do that, e.g., =COUNT

2018-11-26 01:19:03 +0100 received badge  Popular Question (source)
2018-11-25 01:16:06 +0100 asked a question I need to do a count based on multiple columns in a separate spreadsheet. Ideas?

I need to do a count based on multiple columns in a separate spreadsheet. Ideas? I am collecting statistics on one spre

2018-11-25 01:15:42 +0100 asked a question I need to do a count based on multiple columns in a separate spreadsheet. Ideas?

I need to do a count based on multiple columns in a separate spreadsheet. Ideas? I am collecting statistics on one spre