I am stuck on a simple yet seemingly difficult task for excel. All I want to do is count the number of cells for specific columns, yet I haven't found a formula which could work.

j | n | n | j | j |

0 | 0 | 1 | 1 | 0 |

1 | 0 | 1 | 99 | 0 |

0 | 1 | 1 | 1 | 1 |

1 | 0 | 0 | 1 | 1 |

99 | 0 | 0 | 1 | 1 |

0 | 99 | 1 | 1 | 0 |

<tbody>

</tbody>

I need to count the columns for "j" and "n" separately (and add them together), but only for the numbers <2. So for "j" I should receive a result of 5+5+6=16 and for "n" 5+6=11.

Does anybody have an insight into this problem?

Thanks