If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Google Sheets topics you want me to cover in future videos.
@dshotphotography3445
3 жыл бұрын
@SPREADSHEET POINT... GREAT VIDEO!!! THE SCRIPT AND FORMULA SEEM TO WORK WELL. BUT IT WILL NOT POPULATE DATA. ITS SAYS LOADING ..... BUT NEVER ACTUALLY TALLIES THE CELL RANGE. ANY ADVICE? THANKS AGAIN FOR THE RESOURCE
@elleporidae
3 жыл бұрын
I have been searching all day for a simple formula/script combo that works with conditional formatting and does it automatically (without the need to "refresh") and this finally does it! Thank you so much for sharing. You have no idea how helpful it is for the tracker I'm trying to do. I hope more people find this 👌🏻
@SpreadsheetPoint
3 жыл бұрын
Glad you found the video useful :
@julianfann6407
2 жыл бұрын
你的口白不但清楚,速度適中,而且在KZitem的說明清楚有條理,涵蓋了初級與進階的Sheets 使用者;同時你的 SpreadSheetPoint 網頁編寫、排版都非常簡潔、結構化,兼顧平易近人的表達。我比較了2~3種計算儲存格顏色的做法,光是命名就非常符合直覺("Count" is better than "Sum" in my asian English culture),我在一分鐘之內完成複製 App Script,並且在10秒鐘內看到成效,1分鐘後完成15個的顏色統計。 Fantastic!!!Sincerely Appreciation. 你的編撰和思維是我的學習典範。 Your video and web write-up is a role model to my learning.
@jamesklososky6904
2 жыл бұрын
Not only works well, it gives me confidence to write some formulas of my own in the Script Editor, thx!
@connectlanguagecenter4233
Жыл бұрын
You are a lifesaver... I can't believe I finally found the formula I needed. Such a useful video!!! You are the BEST!
@josefalconquispe1232
3 жыл бұрын
thanks bro, everything very well explained, I was with that problem for almost 4 hours. Greetings from Peru.
@SpreadsheetPoint
3 жыл бұрын
Thanks for commenting... Glad you found the video useful :)
@RushdiAshraff
14 күн бұрын
Thanks alot, it works fine.. you saved my day
@marcoterrone
2 жыл бұрын
TypeError: Cannot read property 'pop' of null countColoredCells.....
@Shaeed27
Жыл бұрын
This helped me when Im mostly required of this option.. 😊
@cameleonscorpion
Жыл бұрын
Thank you so much for the link and the video explanation. I used this VBA method you showed, but it didn't work for me, so I looked at the article you linked in description and found an add-ons method that worked perfectly for my data. 👍
@SpreadsheetPoint
11 ай бұрын
Glad it helped!
@mamiagoo4186
2 жыл бұрын
Your video is so useful and you can explain clearly. Thank you !
@carolreal6246
5 ай бұрын
Great explanation! Ty so much for it ♥️
@travelinoadventures9001
Жыл бұрын
Truly, a life saver!!!!! Thank you
@rethcork
2 жыл бұрын
Thanks for the video! Very helpful.
@beabeeeee
2 жыл бұрын
you are a real life saver, thank you!
@mikhaelamalabonga1646
3 жыл бұрын
This worked well! Thank you so much.
@yahbalinho
Жыл бұрын
if it shows error, check the lign 13 and 18 and change , with ; . I did it and it worked !! thank you for a lifesaving trick !!
@joe83912
3 жыл бұрын
This rocks! Thanks a lot
@solliebox6382
2 жыл бұрын
This is brilliant - thank you!
@sashawheeler7126
3 жыл бұрын
I can't seem to get my Sheets program to recognize the fxn after I've successfully run it and saved it. What could be happening?
@DVGNKH
2 жыл бұрын
HUGE thanks, it works!
@SophieThwaites-zi9pq
Жыл бұрын
thank you, very helpful!
@tianurhawa5043
Жыл бұрын
So thank you!!! u made my life easier :)
@blessedlifechannel2971
3 жыл бұрын
=Coloredcountcell is error on my end, how to fix?
@eliudrojas9976
2 жыл бұрын
isn't countcoloredcells? capatilization matters and it has to be written exactly the same as the code
@TrailBlazer5280
2 жыл бұрын
Very nice thank you. Running the script give an error for me but ignore that the script works fine.
@eroesportscenter2069
2 жыл бұрын
Perfect, thanks brother
@krishnapalpanwar8280
2 жыл бұрын
Thank you so much man!
@MahmoudHermes
3 жыл бұрын
It's awesome 👏 thanks brother :) you saved a lot of time for me Today :)
@atomichockey
3 жыл бұрын
Great video. thank you
@advanceautoparts8340
2 жыл бұрын
Very useful info.
@caseypnw
Жыл бұрын
Thank you so much!!!!
@matheusplannerer
3 жыл бұрын
Thank you!
@dimadan1
Жыл бұрын
Hi! I don't understand - you send "countRange" and "colorRef" to function, but they don't use in the function body. I'm not a programmer, but I think we need to use it somehow. Thanks
@XXxxOtakugirlxxXX
3 жыл бұрын
Hello, thank you very much for this easy tutorial, however I can not use it and google tells me "TypeError: Cannot read property 'pop' of null (line 6)." Do you know how I could fix it ?
@stmsolution
3 жыл бұрын
You are in a different region and the separators of your formulas are not a comma, but a semicolon. You need ";" instead"," var rangeA1Notation = formula.match(/\((.*)\;/).pop();
@KellarBR
3 жыл бұрын
@@stmsolution I fixed but it still with the same error. What else could be?
@stmsolution
3 жыл бұрын
@@KellarBR I need to watch your script, it's so hard to say
@arturaskolobuckis2747
2 жыл бұрын
@@KellarBR you also need to do the same in line 11
@justinejaybernardino8340
3 жыл бұрын
Did you have updated version of formula? Where in the counting will be automatically updated when you change something
@milindpkale
2 жыл бұрын
They talked about that issue in the article linked in the description
@CaptainKage
3 жыл бұрын
Great! Do you know how I can make it work with indirect formula?
@hasansiam2838
2 жыл бұрын
Thank You
@aidanknox2430
Жыл бұрын
The code is not working and I can't see why; anyone figure it out?
@SpreadsheetPoint
Жыл бұрын
Hi! Thank you for your comment! We edited the script now it works! Let us know if you have any further questions.
@alesha5838
Жыл бұрын
@@SpreadsheetPoint Hi! TypeError: Cannot read properties of null (reading 'pop'), please help
@SpreadsheetPoint
Жыл бұрын
@@alesha5838 It seems like you may have accidently typed something extra, or haven't clicked the save button before trying to run the script.
@hinglemccringleberry3719
Жыл бұрын
@@alesha5838you need to change the comma to a semicolon in line 6 and 11. Line 6: var rangeA1Notation = formula.match(/\((.*)\;/).pop(); LIne 11: var colorCellA1Notation = formula.match(/\;(.*)\)/).pop();
@HeriSuranegara
3 жыл бұрын
very helpful. but can it count on a specific value as the COUNTIF do?
@maproductions6512
2 жыл бұрын
Any Way to use these with IF Function and COUNTIFS conditions Like Count Items in Col A If Cells in Col B are specific Color?
@hinaresh
Жыл бұрын
Code is showing some error
@Upbeat_Impact
2 жыл бұрын
Awesome !
@sanjaymr6258
2 жыл бұрын
Does it work whenever we change the color( i.e does it get auto refreshed)
@RaviKumar-nd8uh
3 жыл бұрын
I am not able to get the correct sum... What could go wrong....? for exampl .. i have 2 cells of Red and 3 cells of Yellow... I am getting sum as 2 for Yellow and 2 for Red Only
@ritapazzola6616
3 жыл бұрын
Hi, could you tell me how to color the cells of a column based on the contents of a drop-down menu? Thank you
@SpreadsheetPoint
3 жыл бұрын
You can do that using conditional formatting. You will have to set the condition so that it picks the color based on the drop-down selection in the cell
@klemer7896
2 жыл бұрын
👎 dislike because there are many bugs in this script... more then 999 rows? sometimes it counts not correct? refreshing is not really reliable even if I change between tables...? and some more bugs like "loading..." is suddenly the new cell instead the formular.
@alv4ro
10 ай бұрын
Is is possible to count a combination of content and colour? For example, I wanto to count cells that are green and are assigned to Bob
@SpreadsheetPoint
10 ай бұрын
Yes, but you'll need to add a visual basic script to count cell colors!
@user-bb8qo3ru9x
Жыл бұрын
I offten get te error "Exceeded maximum execution time (line 0)" How can I solve this?
@SpreadsheetPoint
Жыл бұрын
There could be a few reasons for this, one is that there are simply too many cells being processed by the custom function and it times out. You could perhaps try selecting two separate sections of your spreadsheet and counting the colored cells in each and then adding them together. You may also want to check that you aren't running several instances of Google Sheets across devices, especially if you running more than one custom function.
@cwleo8888
2 жыл бұрын
Hi Sumit, thank you for the video, i tried using your script, however, i got an error below, do you know the cause ? Error Exception: You do not have permission to access the requested document. (line 4).
@ajsantos3739
3 ай бұрын
Why do I face a error "Circular Dependency detected"
@SpreadsheetPoint
3 ай бұрын
Something in your code is referencing its own cell. Try using this code, then calling function =countColoredCells("range", "color"). Your cell might have something like this inside after you add the app script below: =countColoredCells("A1:A10", "#ff0000") // If you're counting red for example function countColoredCells(range, color) { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var range = sheet.getRange(range); var bgColors = range.getBackgrounds(); var colorCount = 0; for (var i = 0; i < bgColors.length; i++) { for (var j = 0; j < bgColors[i].length; j++) { if (bgColors[i][j] == color) { colorCount++; } } } return colorCount; }
@anhnhatnguyet4628
2 жыл бұрын
count or sum by color text in google sheet, how ?
@alexiety3153
2 жыл бұрын
there is no "script editor" option in the tools tab of my google sheet idk why
@afrojinq
2 жыл бұрын
Check your Extensions tab. Under there, there should be "Apps Script". That takes you to the Script Editor. Google Sheets has recently made changes
Пікірлер: 77