推 arthurduh1: BX 填 =SUM(D2:BW$99)-SUM(D7:BW$99) 140.109.73.249 03/25 03:05
→ arthurduh1: BX2 填 =SUM(D2:BW$99)-SUM(D7:BW$99) 140.109.73.249 03/25 03:06
→ arthurduh1: 然後複製到每一天日期那列的 BX 140.109.73.249 03/25 03:06
→ arthurduh1: $99 可能要改夠大的數字 140.109.73.249 03/25 03:07
→ arthurduh1: 信裡有一個可以直接下拉的寫法 140.109.73.249 03/25 03:08
→ arthurduh1: 不知道哪種對你比較方便 140.109.73.249 03/25 03:08
→ arthurduh1: 啊不對,推文這個還要改一下 140.109.73.249 03/25 03:10
→ arthurduh1: BX2 填 SUM(D2:BW$99)-SUM(BX3:BX$99) 140.109.73.249 03/25 03:11
→ arthurduh1: 然後複製到每一天日期那列的 BX 140.109.73.249 03/25 03:11
→ arthurduh1: 這樣才對 140.109.73.249 03/25 03:11
推 arthurduh1: 複製是指 ctrl+c BX2 這個儲存格 140.109.73.249 03/25 03:14
→ arthurduh1: 不是複製裡頭的公式 140.109.73.249 03/25 03:14
已解決 收到的眾多方法最喜歡的是遞迴 太妙了
https://i.imgur.com/eNC7BXA.png
https://i.imgur.com/dclKNeQ.png
※ 編輯: MikuLover (1.175.180.8 臺灣), 03/25/2024 14:20:26
推 arthurduh1: 收到紅包,甘蝦~ 140.109.73.249 03/25 14:16
推 arthurduh1: 遞迴這個效率和簡潔都有,就是要額外 140.109.73.249 03/25 14:39
→ arthurduh1: 處理一下多算的那些格子 140.109.73.249 03/25 14:39