Count Checked Checkboxes in Excel | Sum if Checkbox is Checked | Formula to Count Checked Checkboxes

แชร์
ฝัง
  • เผยแพร่เมื่อ 17 ม.ค. 2025

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

  • @zulayosoriomorelo8969
    @zulayosoriomorelo8969 13 วันที่ผ่านมา

    Very very helpful! thanks a lot.

  • @dmabk8828
    @dmabk8828 9 วันที่ผ่านมา

    THANK YOU!!!!😇

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

    Thank you. This worked for Google sheets as well, without using the True/False Column and using "true" for a checked box and selecting the checkbox column instead. Thanks for the help!

  • @FaishalErlangga-q9i
    @FaishalErlangga-q9i ปีที่แล้ว

    Thank you for your Tutorial Vid, it's so simple and easy to use.

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

    Superb tutorial! Very clear and informative🤩

  • @KendraWinter-s6r
    @KendraWinter-s6r 2 หลายเดือนก่อน

    Thank you thank you thank youuuuu! Was searching for this answer for over an hour and could not find how to check a box and have it add up values. This is amazing and such a clear tutorial. Going to look real good at work when I share this when I show my boss! Haha

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

    I really have to say thanks for your video, I had try a lot to find this to solve my problems.

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

    Really helpful, thank you

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

    Thanks so much! No one ever adress the checkbox copy problem. It is first solution i See on YT. Very creative and easy. I hope maybe one day MS will improve auto copy for checkboxes in patch. Any way thanks

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

    Great video. Excellent composition of the solution with the use of the CHAR function.

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

    there's this feeling of satisfaction on understanding formulas

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

    Thank you so mcuh!

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

    great lesson, thanks

  • @barr.mrjohn
    @barr.mrjohn 8 หลายเดือนก่อน

    thank you so much

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

    Awesome!!!

  • @DallasRSnider
    @DallasRSnider 18 วันที่ผ่านมา

    I have come back to this video so many times! However, this time I am coming back in hopes to find answers involving the macOS system. I don’t really see that here. How do I change this or what do I change exactly so that Excel can work properly on my new Mac as opposed to a Windows PC?

  • @rtrbs8383
    @rtrbs8383 ปีที่แล้ว +2

    Thank you but VBA code is not in description and It is not working for me as I double click it still entering Edit mode

    • @ChesterTugwell
      @ChesterTugwell  ปีที่แล้ว +2

      The code is in the workbook (link in description below). If the macros are not working then they have been blocked. I've got a video coming out shortly that addresses this.

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

    Hi great Video, it came in handy for what i am doing. I do have a question though I am using this method in a table which auto updates getting the data from a sharepoint list, columns G-L are the only columns that get the data from sharepoint and I have the checkbox in row M (using the VBA Code) however when I update data, its ticking all the checkboxs on the table, do you know how I prevent this and get it to leave the checkboxes as they are when the table updates

  • @p-cwixstrom2939
    @p-cwixstrom2939 ปีที่แล้ว +1

    Hey, the =char(254) does not work for me. Using Office365.. Any advice on this?

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

      Have you checked the cell format to see if its set up as Text and not number etc

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

    How can i make the chekbox activa with single click?

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

    I have a table with check boxes using your second method. I would like only the value of the checked cells to show in another column how do I get to do that I know there must be some link with the checked cell and the cell I want it to show but not sure how too. I have a total of 100 cells

  • @Atudo.
    @Atudo. 11 หลายเดือนก่อน

    I have a question. I’m working on one project and I don’t find the right formula for check boxes. Example: let’s take numbers from 1 to 20 and alocate 2 colours ( orange for odd and green for even ) and we have 4 results where need to stock data ( 1 to 10 = low / 11 to 20 high ) and we have box1 = low even green / box2 = low odd orange / box3 = high even green / box4 = high odd orange. When tick a box on number 1 for example, need in box1 = 1 but tick need to be gone after marking it and then let’s say we select 7, in box1 = 2 … sum and count formulas are not working unless I miss something. Is there any coding that needs to be ajusted ?

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

    I thought I had what I needed but I can't modify the file 😢

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

    Hello, thank you for the videos. I used your Attendance tutorial and whend I paste formula into a Conditional formatting it did not work. Although it did work inside the spreadsheet itself showing True and False on weekdays. Formula I use was corresponding to yours: =OR(WEEKDAY(H$8,11)=6,WEEKDAY(H$8,11)=7,COUNTIF(Holidays_dates,H$8)=1,H$8=""). In my case it was H8. Please advised. Thank you.

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

    Doesn't work on Mac as Char 254 in Windings provides different character :(

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

    Please provide the code

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

    why cant you do =COUNTIF(xx:xx,CHECKED)

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

    thinks