IF cell starts with EXP Count

[DanielBellfield]

Good afternoon Guys and Gals,

After some help with a formula to count specific cells starting with a particular three letters.

In example:

IF B3 Starts with EXP***** Count.

Thanks in advance!

Dan

 

[Fishboy]

Good afternoon Guys and Gals,

After some help with a formula to count specific cells starting with a particular three letters.

In example:

IF B3 Starts with EXP***** Count.

Thanks in advance!

Dan

Hi Dan,

Try the following formula, updating the bold red part to suit where the data ends:

=SUMPRODUCT(--(LEFT(B3:B100,3)="EXP"))

 

[FormR]

Or alternatively:

=COUNTIF(B3:B100,"EXP*")

 

[DanielBellfield]

Hi Fishboy,

Thanks works a treat!

Dan

 

[Fishboy]

Hi Fishboy,

Thanks works a treat!

Dan

Happy to help.

 

[FormR]

Just a note: the COUNTIF() option will probably be more efficient processing wise than the SUMPRODUCT() option.