Countifs only if all other columns are blank

[cadustin]

Hi, I am trying to get an accurate count if only if one column has a number in it. I want to know how many employees are participating in our 401k program, but they could be participating in several plans, so right now my count is off because it may be counting someone twice. Here is an example of my spreadsheet. My base is the age group. In the second line, someone is in both the 401k% and 401kCU%, so it would count as 2 people, but this is the same person. I tried creating a formula, but I cannot get it to work. My count for Over 50 is showing 4, but it should only be 3.

Age Group	401k$	401k%	401kCU$	401kCU%	Roth$	Roth%	RothCU$	RothCU%
31-40
Over 50		19​		19​
41-50	25.00				5.00
31-40						6​
41-50		6​				6​
31-40		6​
41-50		6​
31-40
Over 50		3​
Over 50		6​

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Age Group	401k$	401k%	401kCU$	401kCU%	Roth$	Roth%	RothCU$	RothCU%
2	31-40										7
3	Over 50		19		19
4	41-50	25				5
5	31-40						6
6	41-50		6				6
7	31-40		6
8	41-50		6
9	31-40
10	Over 50		3
11	Over 50		6
Data

Cell Formulas
Range	Formula
K2	K2	=SUM(SIGN(MMULT(--(B2:E11<>""),SEQUENCE(COLUMNS(B1:E1),,,0))))