none
Excel 有這樣的公式嗎? RRS feed

  • 一般討論

  • 想請高手幫忙解救一下~

    我看到有人在很複雜的報表中使用這樣子的sumifs公式去加總多條件在某一段區間內的數字

    例如:  條件1 =M, 條件2 =T,條件1 =B  在WEEK1 ~ WEEK 28 之間的數字加總但是我自己試,怎麼樣都沒有得到正確的數字;

    可以請教各位應該怎麼修改公式呢? 

    問題應該是出在區間設定的嗎? 那個Week 01 ,02 都是文字輸入進去的,這會有影響嗎? 

    =SUMIFS(F:F,I:I,$M$6,$H:$H,$Q$4,$G:$G,M7,E:E,"=>"&N3,E:E,"<="&N4

    數字 條件1 條件2 條件3
    Week 01 1 M S B
    Week 02 1 M S B
    Week 03 1 M S B
    Week 04 1 M S B
    Week 05 1 M S B
    Week 06 1 M S B
    Week 07 1 M S B
    Week 08 1 M S B
    Week 09 1 M S B
    Week 10 1 M S B
    Week 11 1 M S B
    Week 12 1 M S B
    Week 13 1 M S B
    Week 14 1 M S B
    Week 15 1 M S B
    Week 16 1 M S B
    Week 17 1 M S B
    Week 18 1 M S B
    Week 19 1 M t B
    Week 20 1 M t B
    Week 21 1 M t B
    Week 22 1 M t B
    Week 23 1 M t B
    Week 23 1 M t B
    Week 23 1 M t B
    Week 23 1 M t B
    Week 24 1 w t B
    Week 25 1 w t B
    Week 26 1 w t B
    Week 27 1 w t B
    Week 28 1 w t B
    Week 29 1 w t B
    Week 30 1 w t B
    Week 31 1 w t B
    Week 32 1 w t B
    Week 33 1 w t B
    Week 34 1 w t B
    Week 35 1 w t B

    2020年2月6日 上午 04:41