Sumif formular
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
|