Grab the file I used in the video from here 👉 pages.xelplus.com/sum-color-file
@khazza930
4 жыл бұрын
super helpful this video. I had no idea how to create a custom function... also all these little details getting the active cell and a cell's colour. thanks muchly :)
@darlavishu
5 жыл бұрын
Hi Leila, I truly appreciate your work, I keep watching your videos as they are extremely informative and I keep learning new techniques in excel. I see this video has some VBA at a medium level. I wanted to learn VBA from a more beginner level and request you to advise me on where to start ..
@LeilaGharani
5 жыл бұрын
I have a VBA course that will take you from beginner to advanced. If you are interested you can check it out here: courses.xelplus.com/p/excel-vba-excel-macros
@MrElectrifyer
Жыл бұрын
Awesome tutorial! Can't wait to watch and learn from it like I've done with several of your past tutorials 😁 *hits the like button & subscribes before watching.
@upgradetechnicalskills3392
3 жыл бұрын
Hi Leila, Great I have learn a new things. However, I have tried it's not worked for me, because I'm getting the cell color on condition so it was not working. If i will try it manually it's work. Is it possible to do with condition format. if yes please help me out of this. Thanks once again
@MohammadAshooryan
5 жыл бұрын
very usefull. thanks for sharing. plz share another way using excel4macro.
@LeilaGharani
5 жыл бұрын
You're very welcome Mohammad. Glad you find the video useful.
@muhammadizharmahmood6084
3 жыл бұрын
Hi Leila, may I know if I using conditional format for color, why it count all? although base one conditional format only one box have color?
@belgacemdliouah4267
5 жыл бұрын
عمل رائع.. ممتاز
@LeilaGharani
5 жыл бұрын
Glad you like it.
@ishaq79
Жыл бұрын
there is one more option, if you use "Format Painter", then we can avoid Selection Changer function.
@josediaz630
Жыл бұрын
hello, is there a way to count cells that have a border around them?
@mohammadahmed7932
5 жыл бұрын
what will be the formula to get gradually increasing/decreasing values . thanks
@toenbreker
4 жыл бұрын
Does this work with average too?
@larayoudell-gallman3094
4 жыл бұрын
Great tutorial. Everything works fine. Having trouble with the formula automatically updating. I set it up following the instructions and everything works. If I save the document excel stops automatically updating the formula if I make any changes. I have to manually force the cell to update. Has anyone else experienced this if know how I fix this problem?
@alextones8010
3 жыл бұрын
I am have the same problem does any one know how to fix this
@mvohra
3 жыл бұрын
I had the same issue, found this on Google and it worked for me. Just added 2 lines to Leila's code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("A:C")) Is Nothing Then ActiveSheet.Calculate ActiveSheet.EnableCalculation = False ActiveSheet.EnableCalculation = True End If End Sub
@RNTwan
3 жыл бұрын
@@mvohra Thank you for the help. It works
@ThiagoPikcius
2 жыл бұрын
@@mvohra OMG, thank you so much
@anuraagdaga
4 жыл бұрын
I have a range of cells which are conditional formatted with different colors. This doesnt work for that. While summing up in the "Fx" function, the empty cells are treated as " " instead of 0 and hence the overall sum function fails. How can this be handled, please?
@adrianmanzat879
4 жыл бұрын
Hi Leila, Your tutorials are great . The script does not seem to work with conditional formatting colors. Do you have any idea how we can fixed that? If you can help us on this , you'll be a life saver. Thank you .
@floetic095
4 жыл бұрын
The automation doesn't work. "ERROR: Microsoft Visual Basic: Variable uses an Automation type not supported in the Visual Basic." is what keeps popping up when I try to change from general to workbook. Does anyone have a workaround that actually works and makes sense to a VBA newbie? Every site that I have been to that states they have a workaround is filled with jargon that make absolutely no sense to the average person. Thank you!
@pratyushsrivastava7164
4 жыл бұрын
I found this very useful..but at 08:56 you have referred that for any movement in cell, it will calculate automatically. It is not happening in case Color is getting changed, Any idea???
@gridplan
3 жыл бұрын
I'd like to know too. It didn't work for me either. Someone on Stackoverflow had the same problem to which someone replied that color changes don't trigger a recalculation. stackoverflow.com/questions/33417031/application-volatile-for-colored-cells
@mikelennon1078
3 жыл бұрын
How can count the number of same colored cells in a row? Let's say conditional formatting turns some cell's background to Green in each row. How can we automatically get the SUM of the those Green colored cells in each row?
@mseker66
3 жыл бұрын
Best vid ever in this subject. I appreciate you for sharing this. Merci Leila :)
@ejums
4 жыл бұрын
Please how can I apply this when the cells were conditionally formatted? I tried using but its not working. Please help
@YaNykyta
3 жыл бұрын
Instead oI nterior.Color do use something as FormatConditions(1).Interior.Color
@MrBrianb1066
3 жыл бұрын
This is excellent, but is it possible to count instead of sum? Also, can it be set up to count conditionally formatted color? Any help is appreciated! Thanks!
@magskl672
8 ай бұрын
this is what I did for counting yellow cells. Function CountColor(countRange As Range) As Double Dim cell As Range For Each cell In countRange If cell.Interior.Color = 65535 Then CountColor = CountColor + 1 End If Next cell End Function
@Holly-di4ls
4 жыл бұрын
Whenever I try to run codes like this I just get a #NAME? Error and I don’t know why. I’ve copied it exactly. Do I need to do anything to run the code once I’ve typed it in, or do I just save and close the window?
@feffri1
3 жыл бұрын
I am having the same error
@indycaptain69
4 жыл бұрын
Hello, great video. Can you advise how to modify the code if you want the count of color cells (conditionally formatted - upto 5 CF rules ) only and not the sum of cell contents?
@iannpitout1174
Жыл бұрын
No response to this I see
@Reverae
11 ай бұрын
Heres the Code: Function SumColor(MatchColor As Range, sumRange As Range) As Double Dim cell As Range Dim myColor As Long myColor = MatchColor.Cells(1, 1).Interior.Color For Each cell In sumRange If cell.Interior.Color = myColor Then SumColor = SumColor + cell.Value End If Next cell End Function
@DallasRSnider
3 жыл бұрын
Im getting a #VALUE! after doing the simple VB... no clue here haha
@NoChoke
4 жыл бұрын
I found out that some of my cells did not place the total into that cell. I investigated it and found that the format of that cell was not as a number and once it was formatted correctly the totals showed properly. Thank you so much for this tutorial.
@williandepaulagomes4557
5 жыл бұрын
What's uo, Leila! Thanks for your incredible class. I usually use color conditional formatting to see values that are more than, less than or equal to my budget. I have tested this tutorial with this conditional formating, but when I use the immediate to find the color of my cells in SumRange it shows me value 16777215. It means that my cells are uncolored. But cells are colored, I just used the color conditional formatting. How can I solve it?
@jePenseQuoi
5 жыл бұрын
Her function is useless for conditionally formatted cells, which means that her function is entirely useless since I am not about to go format each cell myself based on a value. Basically, you have to cycle through the range and test whether each cell meets some criterion. In other words, you just use the sumifs() function.
@nasirathadjibade8738
3 жыл бұрын
Thank you! That was so easy to follow. When I save the excel document it no longer automatically updates the sum if I change a color. What can I do?
@WiSaAngel1939
3 жыл бұрын
I face that problem too, did you know how to fix it?
@mvohra
3 жыл бұрын
I had the same issue, found this on Google and it worked for me. Just added 2 lines to Leila's code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("A:C")) Is Nothing Then ActiveSheet.Calculate ActiveSheet.EnableCalculation = False ActiveSheet.EnableCalculation = True End If End Sub
@rafaeljuca4880
4 жыл бұрын
Great video and solved me a huge problem. However I had a problem with the aumatically upload. I've tried the activesheet.calculate as mentioned in the video but is not working. Do you know any other method to do so?
@skylerjoemarekchan8313
2 жыл бұрын
Same problem sir... 😭
@francisroman6675
4 жыл бұрын
Thank you for this, Leila! Quick question, is there a way to have a dynamic range? My use case is that when I filter the data source of the values, I need the cell totals to add up to only the cells in the visible range. Thank you!
@F9Tproductions
4 жыл бұрын
I'm using this function to help me build something in Minecraft and it's fantastic
@Llb890
5 жыл бұрын
female superstar of excel leila gharani
@feraskraim936
5 жыл бұрын
Great Laila I 'll try to translate this totorial into arabic and republish ìt on my channel. Of course after your agree.
@navdeepbindra
9 ай бұрын
Hi... Can you help in solving the following excel problem How to calculate the sum of conditionally formatted (colored) cells.. there are many solutions for counting but none for Sum. Please guide.
@brentlomew2375
3 жыл бұрын
@Leila Gharani How do you count cells by conditionally formatted color? There appear to be macro subroutines that can do this but how can it be done as a function?
@sdalela1
3 жыл бұрын
Thanks, this is indeed magic. I am looking for a help however as I need to sum total a cells in a column (or a row or a range or a selection) which are not colored and the value is within 1000+/-1. Could you please help
@sunilpinto8428
4 жыл бұрын
Hi Leila, Nice to know about color character also can consider for function based on requirement. I got above clip while googling about my requirement. But not able to fix it. Can you help me to fix please. I have data in A2 to A10 as {9:15:18:25:32:35:40:48:50} and in B2 to B10 as{4:5:9:15:21:28:42:48:50} My partial requirement fulfilled with this formula in C2 to C10 "=if(ISNA(Match(A2,$B$2:$B$10,0)),A2," ")" Which gave me the result in C2 to C10 as {" ":" ":18:25:32:35:40:" ":" "} Now I colored yellow for all cells of A2 to A10 and colored B4 and B9 as yellow by using the colour function I should get the result in C2 to C10 as {" ":15:18:25:32:35:40:" ":50} Thank you
@ΓιώργοςΧαμπέσης
5 ай бұрын
Hello dear Leila. I also changed the code to count by color and it works perfectly: Function CountByColor(MatchColor As Range, CountRange As Range) Application.Volatile True Dim cell As Range Dim myColor As Long myColor = MatchColor.Cells(1, 1).Interior.Color For Each cell In CountRange If cell.Interior.Color = myColor Then CountByColor = CountByColor + 1 Next End Function but when I add the selectionchange to the sheet I can't do ctrl+C and ctrl+V, when I do it from the clipboard it works. Any instruction ??
@kirkgay3004
2 жыл бұрын
Great video but I found a problem. Whenever the line of code "Activesheet.Calculate" or just "Calculate" is added to the module, it seems to disable the ability to 'cut or copy and "insert copied cells" function on the worksheet. Any ideas as to why or how to fix this?
@svetlanas6910
5 жыл бұрын
Great tutorial. Thank you Leila. How should I save it, so the formula =SumColor is available on every excel file?
@josephking3937
3 жыл бұрын
Thank you so much, this was great but, I followed your instructions and had issues when adding colored cells in a column that were colored by conditional formatting. If I manually create the color on the cell, everything works fine but when I try it on conditional cells, it's not working. any suggestions?
@MdJamaluddin-vx4ko
6 ай бұрын
Hello mam....I am getting error of (+ - 1) or (+ - 2 ) ....while calculating the sum using color code. Suppose I use this method . In calculating some values. But this methods showing +2 or sometime - 2. or -1 ..with the actual result I calculated manually...why it's happening
@AralynEmerile
2 жыл бұрын
This didn't work for me, for some reason. At first, it gave some random calculation. Then upon trying again, it stated Invalid or unqualified reference error .... Even though I copied this word for word!! Confusing
@JiBiT3
15 күн бұрын
Second part (+9:00 forward) refreshing cell formulas did not work for myself. May you please advise for everyone's benefit? Thank you.
@securesquare
2 жыл бұрын
How do we count cells by sumcolour for conditionally formatted color, I have two colors in a column which obtained by conditional formatting (formula based), but when i applied sumcolour it considering both colors same, Any Idea or advice please!!
@abk_asrjc
6 ай бұрын
Hi Leila. Thank you for the video. I've done the selection update as per your tutorial. The numbers are still not updated. I've changed your VBA slightly to count instead of sum by the way.
@sandeepjoshi4635
4 жыл бұрын
Hi Leila, Thank you for video, which is very helpful. My only problem is formulas are not auto updated even after changing the colors I have used the same code as suggested by you. What could be the reasons
@mvohra
3 жыл бұрын
I had the same issue, found this on Google and it worked for me. Just added 2 lines to Leila's code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("A:C")) Is Nothing Then ActiveSheet.Calculate ActiveSheet.EnableCalculation = False ActiveSheet.EnableCalculation = True End If End Sub
@sandeepjoshi4635
3 жыл бұрын
@@mvohra thanks
@larinavigil5225
2 жыл бұрын
Will it work if your only wanting to do this on one column? I entered, and it worked, but when I changed a cell color after entering the code, it didn't reflect changes - I then tried to go back through to figure out the issue and now the sum of the cells with that color aren't displaying! It says "calculation Incomplete", then says "Method 'Range' of object '_Worksheet' failed" I'm wondering if it's because I'm only using 1 column instead of a range with intersect?
@levanibalesiashvili9942
3 жыл бұрын
As I see it you all have a similar problem. Does the formula not work after saving the file? After click save ass select Excel Macro-Enabled Workbook, that's all. After opening file all you need click on enable content.
@josephtort2871
4 жыл бұрын
After entering information in the Immediate Window I'm receiving a window that says: "Compile Error: Expected: Identifier or bracketed expression." Mind you the red cell is highlighted. How can I correct this? Thank you.
@YaNykyta
3 жыл бұрын
You are doing something wrong. As in 99% cases with computer. Did you write exactly: ?activecell.Interior.Color Then putted the mouse pointer at the end of the line and pressed Enter?
@fredneal6338
4 жыл бұрын
Hello Leila, This works fantasticly, however, if I have text in a colored cell within the range, I get a #Value error. Is there a way to have text in the range of cells and still just calculate the cells with numerical values?
@sylvesterj95
4 жыл бұрын
I need to know this too!
@evelyngonzalez9291
3 жыл бұрын
Am I the Only One who is having trouble with the last macro (Where it updates automatically) To keep working once I saved my file? (Please help)
@michaelpaul9372
4 жыл бұрын
Dear Leila, I would like to thank you for this excelent short course. I would like to aske you a question with one of my problems, I want to sum cells with color, 12 different colours which are autmaically coloured by using conditional formula . There are all in one column from 1to 400. I am trying to use your VBA formula but it does not work, do you thing any other way of making it working. I would appreciate if you could assit me resolving this problem. Thank you in advance.
@junnelduluguin5324
7 ай бұрын
Hi Leila, I'm one of your video subscribers, please, I would like to request that you create me an IF or conditional formatting formula to color only one cell that has a total value. Thanks.
@mayshigenobu7218
Жыл бұрын
Thank you for this great function tutorial. I have been trying to implement it on my sheet, but no matter how many times i check the visual basic editor to see if i inputted it correctly, i don't get the Function Arguments dialog box when i press insert function at the end... how can i solve this?
@samiissam2113
Жыл бұрын
Hello thanks a lot for your tutorial i was looking for this for my work .but the problme i face always is that i've to rewrite this modules every time i open my workbook it doesn't save ??and dialogue box shows up asking for a macro ?? i really don't know what to do i will be thankfull if you could help me .
@Lokra_
2 жыл бұрын
Question: It works. But once I close the Excel, when I re-open the sheet, the automatic calculation is not working. I have to do some change of the text without changing it, like drop it 1 line below, for the automatic update to work. How do I make it permanent.
@vj96
4 жыл бұрын
I’m only 5 minutes in but I keep getting the “#NAME?” Error. Can anyone help or tell me what I’m doing wrong?
@seanwhittyphotography
4 жыл бұрын
watch to the end...
@darcyfranklin6369
4 жыл бұрын
@@seanwhittyphotography I also keep receiving this error and I watched to the end and double checked that everything was typed correctly. Not sure if I'm missing something.
@ivaniffah1039
2 жыл бұрын
Hello Ma'am, I really like your videos. This one is one of them. But When I am using this for one of my columns it's not working. meaning no calculation is going on. is it because it's a table. please help me with it. Thank you.
@imtiazimi7109
3 жыл бұрын
how to update result (=sumColor) value without clicking away i.e just by updating the cell color...? please guide.
@theofficialseries
5 жыл бұрын
If I'm typing text in SumRange then formula get me #value error,
@ZNDS91
5 жыл бұрын
I also got the same error.
@tonichkeir2761
3 ай бұрын
Hi, How I make SumByColor and CountByColor functions update automatically ?
@1988Ssk
7 ай бұрын
Hello. I have an Excel sheet which contains number of line items that I have categorised and I have marked all these line items in 4 different colors. If I have to create a summary table to categorise the line items in 4 different colors. How can I do it. Is there any formula which can count the number of colored cells and return the exact number to the specific category and colour.
@SörenRasmussen-j4d
Ай бұрын
Hi Laila I run in to trouble when selecting the range that I want to sum excel telling me that there is a problem with the formula, what am I doing wrong ? Kind Regards Søren Rasmussen
@markonemusic
8 ай бұрын
This doesn't seem to work if the colour of the cell is set by a conditional formatting rule. You can check this if you use the paste format tool and paste the format from a cell you've formatted the colour based on a rule. The pasted format is still the underlying colour before the rule is applied. Can you think of a way around this?
@jluebs
2 жыл бұрын
It's so silly that something that should be so simple, is so complicated to do. Excel needs to add this as a feature. People at my company constantly want to do this, but they aren't Excel experts. It should be a button or a simple formula.
@AshokKumar-hd7pz
5 ай бұрын
Hello Leila I am great fan of yours and learned lot of excel formulas by seeing your vedios now i need a help hope you would help me in our office we have a daily tracker in that we have 12 agents and works in 24/7 shifts we work on incident tickets as soon as the ticket arrives we have enter the ticket number in that sheet and change the color of the cell manually according to the time the ticket arrived for eg. if ticket came in between 8am to 9 am it will be green if it is between 9 am to 10 am then red if it is between 10 am to 11 am then purple so on so instead of changing the color manually i need a formula or a steps so based on current time when the data entered into a cell the color should change please suggest
@VipulKarkar
5 жыл бұрын
Fantastic video: I think, assigning color to variable and than checking will have some overhead if multiple cells have this function. I would go with directly adding it under if condition because checking Boolean is faster than 2 step process of assigning than checking it. If cell.interior.color = matchColor.interior.color then.... will be faster. Thank you for your time Leila.
@LeilaGharani
5 жыл бұрын
Good idea. Thank you!
@fawzyramadan7099
4 жыл бұрын
Thank you for good explain put I need this Equation. =CountCellsByColor( If you can
@masterblob
3 жыл бұрын
What if your captions have the background color, but the numbers don't? How would you change the macro when the criteria range is in one row or column, and the sum range in a different row or column?
@andrec9186
Жыл бұрын
Hello, I want to do something a bit different. I want to add how many cells are red or yello or green only red cell in a table must be added. If UI have 26 red cell i want the result to be 26 I use your vba formula but it doesnt work Thanks
@jasonaraiza4686
23 күн бұрын
Can you make a video showing how to get a percentage of a certain color of a cell? For example I have due dates for when certain tools we use need to be inspected they usually are only good for one year so I created a table with a list of tools and their due date then I used conditional formatting to highlight when it’s expired to be in red when it’s less than 30 days to the due date to be in yellow and when it’s more than 30 days from the due date to be in green and I want to show a percentage of how many tools are not expired or how many green cells I have and to be able to show it in a bar or a graph somehow to look more professional. Can you please help with this I have looked for a video on here with no luck. You are the best I’ve seen at this so I hope you could help me out. Thank you in advance.
@dominikalaszkiewicz311
2 жыл бұрын
Mine looks like it isn't working can you please help me out why ?? I did all the same as on the video but it is giving me Name? Error please help :(
Good day I just want to know how to fix this error, Variable uses an Automation type not supported in Visual Basic?
@poojajodh2983
2 жыл бұрын
hello mam can i do it this function =SUMIF(B1:B3,SUMCOLOR(C4,A1:A3))
@mrbob92679
2 жыл бұрын
Thank you very much for this. Only problem is I can not get the Selection Change to work. Ill have to keep working on it . I only selected one row to test it.
@tonykenny7048
3 жыл бұрын
Hi All. I have created a spreadsheet which includes some conditional formatting to make cells change a date and colour dependant on another cells update. I want to be able to automatically add up how many cells become green, how many red, etc. I need it to automatically update when ever I change the cell date in the one main cell. Can any one help. Please.
@jefwhestler1195
11 ай бұрын
Hi thank you for this amazing info. I have also a question. When i ad 2 colors white and green, and fill in a number in the white one and i change it to the green color it will not count the value. How can I solve that?
@Hardiknandha
4 жыл бұрын
If Cells Are *Coloured* Using *Conditional Format* Will This VBA Work Then?
@leahlow312
2 жыл бұрын
Mine just says #VALUE!
@maxbernacchi
5 жыл бұрын
hi Leila, thanks for this video, very useful. I would like to ask you an update to it. In case I have to sum cells with conditional formatting it doesn't work. I tried to add the instruction "DisplayFormat" before Interior.Color but it's not working as well. Using excel 2016.
@ejums
4 жыл бұрын
Same issue, have you figure this out please?
@menno_menno
3 жыл бұрын
When I use the formula in a table and filter it the cell shows #VALUE. After selecting the cell and press enter the value of the cell is again the outcome of the some. I have to do this for all the filtered cells however, since the other rows are not update like with real Excel formulas.
@_Tezza
3 ай бұрын
How do you make this work with conditional formating using the same colours?
@lkrizo6448
Жыл бұрын
Hi. Can you make a formula / when the cell change the color , cell next to it will show the date. Thank you
@TheFearco
2 жыл бұрын
Great tutorial! I Wonder, what should I change to count the colored cells? I tried changing the IF code to count instead of sum, but than I get the Value error
@ChardLanceCasper
4 жыл бұрын
It will not work if the color in the cell is conditional format. How you can sum the color of Conditional Formating?
@harshtandon2511
4 жыл бұрын
Leila Madam, Can you plz make a video on "How to get the output of "if else statement" in different desired colours" automatically?
@saijupv4723
Жыл бұрын
This is not working in conditional formatted cells. Any workaround?
@mathewsenan8167
4 жыл бұрын
there any way to sum cell by color in excel without VBA and get it update automatically.
@sanjaykasbe7240
4 жыл бұрын
Hi LEila can you help me out in this, fuction SumColor(sumRange As Range)As Double error comes on AS always = compile error list separator or )
@andyclement40
3 жыл бұрын
Did you find the solution?
@OzduSoleilDATA
5 жыл бұрын
Oh lord! VBA. 😱
@LeilaGharani
5 жыл бұрын
I know, right? :)
@LisaM-em3hb
Жыл бұрын
Hi, this is a great tutorial. Is it possible to do the same thing using Office Scripts?
@mohammadmt7916
2 жыл бұрын
Hi, when I reopen it and change color of cells it does not work. how should I fix it?
@yoyohaney8002
Жыл бұрын
its showing variable not define could any one plz comment the exact code
@marteneqdt
2 жыл бұрын
Great video, unfortunately it's too complicated for my level 😕 😆
@spg1957
3 жыл бұрын
Thanks for the great tutorial, Using Office 2019 and applied following code but not auto updating, please help Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Target, Range("A:E")) Is Nothing Then ActiveSheet.Calculate End If End Sub
@mvohra
3 жыл бұрын
I had the same issue, found this on Google and it worked for me. Just added 2 lines to Leila's code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("A:C")) Is Nothing Then ActiveSheet.Calculate ActiveSheet.EnableCalculation = False ActiveSheet.EnableCalculation = True End If End Sub
@lspam22
Жыл бұрын
How would you amend this formula for average of colored cells rather than sum?
@KyleJason-h3v
Жыл бұрын
It doesnt seem to work with cells that are conditionally formatted to the match color. Is there a solution for this?
@ericiriarte2880
5 жыл бұрын
Por casualidad saben dónde puedo descargar un mapa vectorizado de Argentina. O las provincias de Argentina por separado?. Lo que quiero hacer es referenciar una celda con la imagen de la provincia. Ej en A1 una lista desplegable de las provincias y en B1 que me traiga automáticamente la imagen de dicha provincia. Espero me puedan ayudar!!!! Referenciar una celda con una imagen es fácil... Lo que se me complica es encontrar la imagen o el mapa vectorizado. Graciasss
@LeilaGharani
5 жыл бұрын
You can try this: freevectormaps.com/
@augustajb
3 жыл бұрын
is there a way to make this formula usable in all other workbooks going forward?
@Spectre.007
3 жыл бұрын
What if i want the values of the cell with color to display in another cell to sum it up? How to do it?
Пікірлер: 558