Analysis countif?

[xxsalahxx]

Hello
I have a spreadsheet that has a median column in it (Column J on a data sheet) on my analysis sheet im trying to count if scores in column J in my data sheet are over a 3 and i want to include the blank cells in this column also.

Ive tried using =COUNTIF(Data!J:J,">3")*AND(J:J="","",J:J)
but cannot get this to add up, any suggestions?

Thanking you in advance

 

[Soggy]

You can use:

=COUNTIF(Data!J:J,">3")+COUNTIF(Data!J:J,"")

but this will give you the problem where you are adding in the blanks where the data range does not extend to. I.e. if you have 5000 lines of data it will count the other 60,000 (excel 2003).

If you could have a zero or maybe a space instead you could modify to work.

 

[Robert Mika]

please do not whole range as it take long to count (unless you have to)
And as soggy sugested it will count all blanks in this column.

Excel Workbook
	I	J
1	5	4
2	*	1
3	*	*
4	*	33
5	*	*
6	*	4
Sheet1

Excel Workbook
	I	J
1	1048575	4
2	*	1
3	*	*
4	*	33
5	*	*
6	*	4
Sheet1

 

[xxsalahxx]

Thank you it worked!
Much appreciated.

 

[Robert Mika]

Thank you it worked!
Much appreciated.

You are welcome