How to exclude cells from a range in Excel?

E

E

EvgenyApMr2020-04-21 23:03:59

Visual Basic

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

How to exclude cells from a range in Excel?

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

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

I

iamarsenibragimov2017-09-28 11:03:17

What mimics human behavior on a smartphone? 2Reply

A

Alexander Ter2017-09-27 14:40:52

Visual studio can't remove dll? 0Reply

Z

Zaicheg2017-10-02 12:03:55

Is it possible to batch save from DOCX to PDF with one button formatting preserved? 1Reply

A

acspro2017-10-06 00:27:48

How to declare a variable with Dictionary type in asp? 1Reply

N

Nikolai Chuprik2020-03-16 19:28:17

What causes Error 451? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question