SumProduct Formula Problem

[Nickie]

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

 

[Mike H]

Nickie,

Youe were close, try this

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

Mike

 

[Barb Reinhardt]

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.

 

[Nickie]

Thank you very much for your prompt response Mike, that did sort the problem

Kind regards

Nickie

 

[Mike H]

Your welcome

Thank you very much for your prompt response Mike, that did sort the problem

Kind regards

Nickie