SumProduct Formula Problem
 

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

SumProduct Formula Problem
 

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

SumProduct Formula Problem
 

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

SumProduct Formula Problem
 

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

Kind regards

Nickie

"Mike H" wrote:

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

SumProduct Formula Problem
 

Your welcome

"Nickie" wrote:

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

Kind regards

Nickie

"Mike H" wrote:

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