ExcelBanter - COUNTIF using exclusions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - COUNTIF using exclusions (https://www.excelbanter.com/excel-worksheet-functions/69117-countif-using-exclusions.html)

djDaemon

COUNTIF using exclusions

I have a column containing part numbers. I want to count the number of times
a part beginning with "RY..." occurrs. However, I wish to exclude the parts
that end with "...GBMK".

Could this be done easily with COUNTIF?

Any suggestions?

JMB

COUNTIF using exclusions

If your data is in B11:B14:

=SUMPRODUCT(--(LEFT(B11:B14,2)="ry"),--(RIGHT(B11:B14,4)<"gbmk"))

Modify your range as necessary. Sumproduct cannot accept entire columns
such as A:A or A1:A65536, but A1:65535 is okay.

"djDaemon" wrote:

I have a column containing part numbers. I want to count the number of times
a part beginning with "RY..." occurrs. However, I wish to exclude the parts
that end with "...GBMK".

Could this be done easily with COUNTIF?

Any suggestions?

All times are GMT +1. The time now is 06:36 AM.