EE
Lv 4

Excel sumif count anotherSHEET

http://i199.photobucket.com/albums/aa194/taioiying...

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.

3 Answers

Rating
  • 1 decade ago
    Favorite Answer

    跨表sumif的公式是沒有問題

    問題在于 2009!k欄的數字是文字值 "1", sumif (或 sum) 會將文字值視作0。

    請將2009!K2的公式改為

    =IF(E2="","",1)

    請測試

    • Login to reply the answers
  • 1 decade ago

    文字"1"跟數字"1"真的好容易攪錯

    • Login to reply the answers
  • joe
    Lv 7
    1 decade ago

    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.

    • Login to reply the answers
Still have questions? Get your answers by asking now.