Help with SUMPRODUCT
 

=SUMPRODUCT((crq1!$B$2:$B$10000="app")*(crq1!$F$2: $F$10000="Sys")*(crq1!$H$2:$H$10000=""))

Column €˜H contains blank cells and cell with random numbers.

My result is falling short compared to when I €˜filter the data and do a
manual count. Where am I going wrong with counting the random numbers in
column €˜H?

Number consist of 13 digits, i.e. 4000000123456 etc. no one number (per
cell) is the same.

Regards

EricB

Help with SUMPRODUCT
 

Are perhaps some of the blanks actually containing spaces instead of
true blanks?


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111028

Help with SUMPRODUCT
 

I cleared the cells - Same result. Added a space to all blank cells but
result remains wrong..

Regards

EricB

"NBVC" wrote:


Are perhaps some of the blanks actually containing spaces instead of
true blanks?


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111028

Help with SUMPRODUCT
 

How about columns B and F? Are there perhaps extra spaces at the end or
beginning of any of the cells and/or spelling ok?


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111028

Help with SUMPRODUCT
 

Sumif, Countif, SumA, SUmproduct etc, all work well on the other cells

?

"NBVC" wrote:


How about columns B and F? Are there perhaps extra spaces at the end or
beginning of any of the cells and/or spelling ok?


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111028

Help with SUMPRODUCT
 

Unless I see a sample workbook..then, I can't tell you why... the
formula looks ok..


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111028