Help with Count Function to create MI

[kenadams378]

Hi,

I need to use a count function across 3 columns of data to produce some MI based on this changing data

I need to document the following;

- No of cases
- No of NULL cases across 3 columns
- No of NULL cases across 2 columns
- No of NULL cases across 1 column

I have attached sample data

[Fotis1991]

Hi

Do you mean?

=COUNTA(A2:C18)

=COUNTIF($A$2:$A$18,"[NULL]")

=COUNTIF($A$2:$b$18,"[NULL]")

=COUNTIF($A$2:$c$18,"[NULL]")