=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