http://i199.photobucket.com/albums/aa194/taioiying/ScreenHunter_11Jun191312.gif
Problem Detail : please click the above link to see detait . ^_^
thanks a lot ! for yours help !!
problem explain : wanted use sumif formula to count another sheet's qty.
Excel sumif count anotherSHEET
2009-06-19 9:28 pm
回答 (3)
2009-06-19 10:00 pm
✔ 最佳答案
跨表sumif的公式是沒有問題問題在于 2009!k欄的數字是文字值 "1", sumif (或 sum) 會將文字值視作0。
請將2009!K2的公式改為
=IF(E2="","",1)
請測試
2009-06-19 11:16 pm
文字"1"跟數字"1"真的好容易攪錯
2009-06-19 10:03 pm
Your work does not seem to have any error. It looks fine. In order to detect the "error" further, please e_mail the file to me so that I can have a more detailed look at the formulas.
Cheers.
Cheers.
收錄日期: 2021-04-23 23:21:49
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20090619000051KK00809