Nickie,

Youe were close, try this

=SUMPRODUCT(('hand portable on trains'!B2:B318="District")*('hand portable
on trains'!I2:I318<""))

Mike

"Nickie" wrote:

I need a formular that will give me the total number of records that in
B2:B318 which equal "District" and I2:I318 for those records are not null,
this is what i have so far:
=SUMPRODUCT(('Hand Portable on Trains'!B2:B318="District")*('Hand Portable
on Trains'!I2:I318="<"))

Any help would be much appreciated

Kind regards

Nickie