Hi,

I have gotten the below formular, to work on my excel
=SUMPRODUCT(--(listing!$A$5:$A$1942="04"),--(listing!$B$5:$B$1942=3009),(listing!$S$5:$S$1942) )

However, I found that some time the formular works and sometime it doesn't.
I soon figure out that it had to be due to both column A and B.
In the data sheet, should I format both columns to General, Text or Number
format?

When I use the formular, should I put in the " " or should I just lift the "
" out?
Can someone advise please. Thanks