Counting blank cells and columns

[ABGTH]

I have four columns for attendance for each quarter. How do I count if all four are blank for a person and then total that at the end? The highlighted cells are representative the person did not attend all year.

 

[Fluff]

Hi & welcome to MrExcel.
What are your expected results for that data?

 

[ABGTH]

I am wanting a percentage of the number of people that attended at least one of the four meetings during the year. I have 230 people total. How many of the 230 attended at least one meeting?

 

[Fluff]

That does not really answer my question & is totally different from what you asked for.

 

[ABGTH]

I apologize. I guess I did not understand your question. I will mark as solved and close the question.

 

[Fluff]

There is no need to close it, can you please just answer my question.

 

[ABGTH]

What is your question? I still do not understand what you are asking.

 

[Fluff]

I am asking what you expected results are.

 

[ABGTH]

40%?

 

[Fluff]

Not sure how you get 40% with the data in your image, but is this what you want.

Fluff.xlsm
	A	B	C	D	E	F
1	March	June	Sept	Nov
2
3						33.33%
4
5	P		P
6	P
7
8
9
10	P
11
12
13		P
14
15
16				P
Data

Cell Formulas
Range	Formula
F3	F3	=SUMPRODUCT(SIGN(MMULT(--(A2:D16<>""),TRANSPOSE(COLUMN(A2:D2)^0))))/ROWS(A2:A16)