Help with SUMPRODUCT

  • Thread starter Thread starter EricB
  • Start date Start date
E

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
 
I cleared the cells - Same result. Added a space to all blank cells but
result remains wrong..

Regards

EricB
 
Back
Top