Count a formula

[Foxy Lady]

Hi there,

I need assistance.

I need a macro that will return a formula.

For instance

I need to count how many (a) b and (c) there are.
If I have the following vallue in the following cell

A1 = A Balance
A6 = A General
A7 - B Balance
A8 = B Balance
A9 = C General
A10 = A Balance
A11 = B General
A12 = C General
A13 = B Balance
A14 = C Balance
A15 = B Turn
A17 = B Turn
A19 = C Jump
A20 = A Turn

The outcome of this macro should then be in the form of a message box:
Tricks: (1A General, 2A Balance) A's formula should also be place in B55
(1B General, 2B Balance); B's Formula should also be placed in E55
(2C General,1C Balance) C's Formula should also be place in H55
Turns: ( 1A Turn) (2B Turns) A's forumula for turns should be place in B56 and B's Turn should be place in E56
Jumps: (1C Jump)

Basically it needs to count how many A General, A Balalance; B General, B Balance; C General, C Balance, A Turns, A Jumps; B Turns, B Jumps; C Turns, C Jumps there is and apply it the cells mentioned above.

Hope someone can help me with this

 

[shift-del]

Hello

Use COUNTIF().
For example: =COUNTIF(A1:A100,"A Balance")