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

I would try

=SUMPRODUCT(--(listing!$A$5:$A$1942=4),--(listing!$B$5:$B$1942=3009),(listing!$S$5:$S$1942) )


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"YMTEO" wrote in message
...
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

thanks. working fine now.

"Bob Phillips" wrote:

I would try

=SUMPRODUCT(--(listing!$A$5:$A$1942=4),--(listing!$B$5:$B$1942=3009),(listing!$S$5:$S$1942) )


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"YMTEO" wrote in message
...
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