Need to apply individual True/False Value, to Multi-Cell Ratio Count Formula

Greetings!

I have a sheet in which Col 'F', has two posible values ("J" and "A") for each Row F6:F30. The J & A Values are determined by a VLOOKUP table on an adjacent sheet which is working great. The count formula for 'F' is: =(COUNTIF(F6:F30,"J")&":"&(COUNTIF(F6:F30,"A"))) which returns a Ratio (i.e. 1:1) (J:A Respectively).

In Col G, I have inserted check Box's for each Row (G6:G30). With the intended result being: True = Count, False = Do Not Count, With the True/False Output in Col H (H6:H30).

How do I get the Ratio Formula in Col 'F' to count -or- not count each individual 'F' cell (F6:F30) based on the individual (H6:H30) True/False Output???

Thank You!

Awesome,

Thank you both, I will give them a shot and reply back with results.

Thanks again to both of you, I am genuinely grateful for your help.

Results:

=SUM(--(IF(H6:H30,F6:F30)="J"))&":"&(SUM(--(IF(H6:H30,F6:F30)="A")))

- Returned N/A in Ratio Field

=COUNTIFS(F6:F30,"J",H6:H30,TRUE)&":"&COUNTIFS(F6:F30,"A",H6:H30,TRUE)

- Works great!

I am in Business, Thanks Again!!!

j