| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct formula problem | Excel Worksheet Functions | |||
| Problem with SUMPRODUCT formula | Excel Worksheet Functions | |||
| Problem with SUMPRODUCT formula. | Excel Discussion (Misc queries) | |||
| Problem with a SUMPRODUCT Formula | Excel Worksheet Functions | |||
| Problem w/ A Sumproduct Formula | Excel Worksheet Functions | |||
![Nickie[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
