Get value from Nth row convert value and paste result in different sheet

[GaithS]

Hello,

I have created an excel file where employees can create projects and follow an introduction process. I want to get the summarized then converted to one cell as green red or yellow.
The status bar moves every 17th row. i want to go to the row get the data from x columns then from y column and summarize in different sheet.

As of now i am using: =IF(COUNTIF(F17:F26;"Röd");"Röd";IF(COUNTIF(F17:F26;"Gul");"Gul";IF(COUNTIF(F17:F26;"Grön");"Grön";""))) [Grön=Green Röd=Red Gul=Yellow]
To summarize column to rows.

And this: =IF(COUNTIF('Uppföljning tidsplan'!F27:K27;"Röd");"Röd";IF(COUNTIF('Uppföljning tidsplan'!F27:K27;"Gul");"Gul";IF(COUNTIF('Uppföljning tidsplan'!F27:K27;"Grön");"Grön";"N/A")))

To get the sum from rows and get an overview.

I hope you can understand my problem if not please ask.

I want to make this in to VBA. thanks in advance

 

[GaithS]

Anybody?