Count formula

[Pjesani]

I have two spreadsheets.

I am trying to count how many postcodes have provided in the second spreadsheet(property details)

I'm using =COUNTA('Property details'!$F:$F)-2 but it gives me -1. Does anybody know why?

 

[Pekkavee]

It only finds one postcode and 1 - 2 = -1

Am I missing something ?

Pekka

 

[Aladin Akyurek]

Care to provide a tiny sample along with the desired count?

 

[vconfused]

If you just need a count of nonblank cells in column F on the Property Details page then remove the "-2" and leave the formula "=COUNTA('Property details'!$F:$F)".