How to use SUMIF and SUMIFS function in Google Sheets

แชร์
ฝัง
  • เผยแพร่เมื่อ 18 ธ.ค. 2024

ความคิดเห็น • 10

  • @HashAliNZ
    @HashAliNZ  ปีที่แล้ว +1

    Want to follow along and try out your sumif skills? Here's the spreadsheet used in this tutorial ➡ docs.google.com/spreadsheets/d/1lYh88GGX67-XbDvwG2xbNNk13rU-JNZ5JaxyBnEiBRQ/copy

    • @yazdanicacid
      @yazdanicacid ปีที่แล้ว

      Hey, I clicked on the link to follow along and it's requiring us to request access. I sent you a message, hoping I can get access soon to follow along! Thanks

    • @HashAliNZ
      @HashAliNZ  ปีที่แล้ว +1

      @@yazdanicacid Oh sorry! Settings have been updated so you should be able to make a copy now

    • @yazdanicacid
      @yazdanicacid ปีที่แล้ว

      @@HashAliNZ Thanks! I can copy it now. Also, it seems like the sheets from that link are in their completed version, rather than the raw version to follow along in. For example, in the Basic sheet, all the formulas are there already, and in the account manager sheets there are some account managers highlighted, etc

    • @HashAliNZ
      @HashAliNZ  ปีที่แล้ว +1

      ​@@yazdanicacid It's all fixed up now. Thanks for the heads up!

  • @elenarobitu2370
    @elenarobitu2370 หลายเดือนก่อน

    This is really helpful! Thank you so much for the very comprehensive tutorial! Great job 🙏

  • @MikoajGano
    @MikoajGano 7 หลายเดือนก่อน

    Thank you. Especially for the arrayformula solution for multiple criteria, that's very useful.

  • @NiraaStar
    @NiraaStar ปีที่แล้ว +1

    So helpful! Thank you!

  • @vktriazz
    @vktriazz 2 หลายเดือนก่อน

    How did you create a table above, where selecting a manager from the dropdown list, you can see them highlighted in the left table?

  • @lalinsoliman3845
    @lalinsoliman3845 28 วันที่ผ่านมา