Sumif formular

[YMTEO]

Hi,

I have gotten the below formular, to work on my exce
=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

 

[Bob Phillips]

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]

thanks. working fine now.

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)