[Excel] Swert Ai's Question



  1. Cell D5 输入以下formula
    2. =SUMIFS('paste output'!K:K,'paste output'!KK:KK,"Day",'paste output'!KM:KM,output!B5)

  2. Cell E5 输入以下formula
    3. =SUMIFS('paste output'!K:K,'paste output'!KK:KK,"Night",'paste output'!KM:KM,output!B5)

  3. Copy D5 and E5
  4. Paste 至D6到E18
  5. 完成




Source: ---

Disclaimer: The information in this webpage is shared by anonymous users from external online sources. We cannot guarantee its accuracy or truthfulness. Users should exercise caution and verify information independently.

© 2023 maginokarp.com