SumProduct Formula Problem

N

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
 
M

Mike H

Nickie,

Youe were close, try this

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

Mike
 
B

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.
 
N

Nickie

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

Kind regards

Nickie
 
Top