Hello MrExcel
I'm atm trying to make a VBA Code that works the same way as CountIf in excel. The Countif i'm useing in excel goes like this =CountIf(B2:B100;2 - Not good) (this goes for all the prioritys 1 - 3). I was hoping you could help me make this to VBA Code, and will be able to look like this.
<tbody>
</tbody>
This is a outtake from my excel
<tbody>
</tbody>
I'm atm trying to make a VBA Code that works the same way as CountIf in excel. The Countif i'm useing in excel goes like this =CountIf(B2:B100;2 - Not good) (this goes for all the prioritys 1 - 3). I was hoping you could help me make this to VBA Code, and will be able to look like this.
Priority | Amount |
1 - Really bad | 1 |
2 - Not good | 2 |
3 - OK | 2 |
SUM | 5 |
<tbody>
</tbody>
This is a outtake from my excel
A | B | C | D | E | F | G | H | ||||
Case | Priority | Title | Title-Long | Status | Project | Type | Tags | ||||
1355512 | 3 - OK | Title1 | TitleName 1 |
<tbody> </tbody> |
<tbody> </tbody> | Bug | Blank | ||||
4215211 | 2 - Not good | Title2 | <tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | Bug |
<tbody> </tbody> | ||||
4213451 | 1 - Really bad | Title4 | <tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | inquiry |
<tbody> </tbody> | ||||
4142341 | 2 - Not good | Title10 | <tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | inquiry | Tag 3 | ||||
1456621 | 3 - OK | Title 6 | <tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | Bug | Tag 5 |
<tbody>
</tbody>