Use countif based on value and cell color in formula

Hey

I am currently creating an overview Excel for our communication project.
In rows 7, 8, 9 and 10 (starting from column C) all the planned social media posts will be filled in. differentiating the type of post. 1 being a static visual, 2 dynamic template, 3 a video and 4 a premade template.
Each type has a specific cost. For easy counting lets use the following values:

1: 100
2: 200
3: 300
4: 50

I wanted one cell which contained the total cost of all the post. Therefore I used the following formula:

=(countif(C7:XFD9;1)*100)+countif(C7:XFD9;2)*200)+countif(C7:XFD9;3)*300)+countif(C7:XFD9;4)*50)


For previous project there wasn't an issue because all posts were posted on the same account.
For this new project we have several diffrent accounts and I would like to assign a specific color to each one.

Main account: green (A8)
Second account: Pink (A9)
tertiary account: Yellow (A10)

As before I would like to calculate the total cost of all the different posts but only in cell A8 only for the main account (green), cel A9 for the second account (pink) and in A9 only for our tirtiary account.
So the formula will need to take the color of the cells into account.

Creating an UDF so I can use it in other formulas would be ideal.

I tried to modify the CountcColor VBA code to add an additional condition but can't seemd to make it work and don't really see how I could put it in the above formula.
Been looking online for several hours and can't seem to find it. :/


Thanks in advance!

Hey

Thank you for pointing it out

I tried to edit my post but it won't add me any links. Even when I put it in this format mentioned on the website.

Error: "You are not allowed to post any kinds of links, images or videos until you post a few times."

Thanks for posting the link for me!