Count rows, based on two criteria across multiple columns (with blanks)

**NV Social Worker** · 07-15-2021, 06:24 PM

I need a formula in one worksheet to count rows on a second worksheet, based on criteria in the second and a third worksheets. The range is C3:CX41, with multiple blanks. I need to know how many people in a given home participated in at least one activity (marked with an "X" on the worksheet containing the data). For example, there should be 2 of the 3 people in 1300 W that participated in at least one activity, but every formula I try gives me a different number, none of which is 2. Any assistance provided would be most appreciated.

**alansidman** · 07-15-2021, 06:41 PM

The problem that you are having is that your layout is not normalized for analysis. You would be better served if you had your data in the following format.

Excel 2016 (Windows) 32 bit

	A	B	C	D
1	Name	Home	Date	Activity
2	Amelia	1300W	6/1/2021	Bingo
3	Amelia	1300W	6/1/2021	Snack

Sheet: Sheet1

With your data in this manner, you can then use =Countifs function to filter your data as required.

Count rows, based on two criteria across multiple columns (with blanks)

LinkBack

Thread Tools

Rate This Thread

Display

Count rows, based on two criteria across multiple columns (with blanks)

Re: Count rows, based on two criteria across multiple columns (with blanks)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count if based on rows that contain multiple OR criteria

Need to count rows based on multiple criteria, each across multiple columns!

[SOLVED] Count number of occurrences based on criteria in multiple columns and rows

[SOLVED] count and sum based on criteria in multiple columns

Count Rows and Lookup Cells based on Multiple Criteria Columns

count rows based on multiple criteria

Deleting blanks rows based on multiple criteria

Bookmarks

Bookmarks

Posting Permissions