Help with SUMPRODUCT

[EricB]

=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

 

[NBVC]

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

 

[EricB]

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

Regards

EricB

 

[NBVC]

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?

 

[EricB]

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

 

[NBVC]

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