How to exclude cells from a range in Excel?

E

EvgenyApMr2020-04-21 23:03:59

Visual Basic

EvgenyApMr, 2020-04-21 23:03:59

Good evening!)

Tell me how to count only those cells "B" that do not fall under the brown columns?
That is, you need to remove 8 cells (H6, I6, O6, etc.) from the range = COUNTIF (E6: AH6; "B") * 1

Or otherwise: how to count those "B" that fall under the desired columns?

Reply

Answer the question

In order to leave comments, you need to log in

0 answer(s)