I'd try

=SUMPRODUCT(--('Hand Portable on Trains'!B2:B318="District"),--('Hand
Portable
on Trains'!I2:I318="<"))

I'm not sure what the "<" means though.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"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