AppleScript Numbers : Part 1 

could you do a video on how a script would look like which lets you open a numbers dokument and then select a table and lets you sort it by the row you want

I suppose that such videos should begins from the explanations how to open script editor

Function Colorsum(ColorMatch As Range, RangeSum As Range) Dim cell As Range Dim ColorCheck As Long ColorCheck = ColorMatch.Cells(1, 1).Interior.Color For Each cell In RangeSum If cell.Interior.Color = ColorCheck Then Colorsum = Colorsum + cell.Value End If Next End Function Function ColorCount(ColorMatch As Range, RangeCount As Range) Dim cell As Range Dim ColorCheck As Long ColorCheck = ColorMatch.Cells(1.1).Interior.Color For Each cell In RangeCount If cell.Interior.Color = ColorCheck Then ColorCount = ColorCount + 1 End If Next End Function

Hello, thanks for your videos. Can you help me? How to SUM or COUNT Cells by Color in Numbers? I use VBA method in Excel according to this video (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-_uk-2PP40K8.html ) which is describing using ColorSum code created in VBA module. Can I write the same code in Apple script Automator app? Im trying to count for example how many green, yellow or red cells I have in the spreadsheet. Then if there are numbers in the colored cells I SUM them by color. Here is the code for it.