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!
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!
| Master file Elite Series KOPIE.xlsm | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB | BC | BD | BE | BF | BG | BH | BI | BJ | BK | |||
| 1 | Zo | Ma | Di | Wo | Do | Vr | Za | Zo | Ma | Di | Wo | Do | Vr | Za | Zo | Ma | Di | Wo | Do | Vr | Za | Zo | Ma | Di | Wo | Do | Vr | Za | Zo | Ma | Di | Wo | Do | Vr | Za | Zo | Ma | Di | Wo | Do | Vr | Za | Zo | Ma | Di | Wo | Do | Vr | Za | Zo | Ma | Di | Wo | Do | Vr | Za | Zo | Ma | Di | Wo | Do | ||||
| 2 | 1-nov | 2-nov | 3-nov | 4-nov | 5-nov | 6-nov | 7-nov | 8-nov | 9-nov | 10-nov | 11-nov | 12-nov | 13-nov | 14-nov | 15-nov | 16-nov | 17-nov | 18-nov | 19-nov | 20-nov | 21-nov | 22-nov | 23-nov | 24-nov | 25-nov | 26-nov | 27-nov | 28-nov | 29-nov | 30-nov | 1-dec | 2-dec | 3-dec | 4-dec | 5-dec | 6-dec | 7-dec | 8-dec | 9-dec | 10-dec | 11-dec | 12-dec | 13-dec | 14-dec | 15-dec | 16-dec | 17-dec | 18-dec | 19-dec | 20-dec | 21-dec | 22-dec | 23-dec | 24-dec | 25-dec | 26-dec | 27-dec | 28-dec | 29-dec | 30-dec | 31-dec | ||||
| 3 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 4 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 5 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 6 | Betaling admins | Q4 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 7 | Communicatie | 1 | 1 | 1 | 1 | 4 | 4 | 4 | 1 | 1 | 3 | 1 | 1 | 1 | 4 | 4 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 8 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 9 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 10 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 11 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 12 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 13 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Data | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A13 | A13 | =A9+A11+A12 |
