COUNTIF when a criteria is a formula RIGHT(LEFT

[bond002]

Hi guys,

Relatively simple problem (or at least appears to be)...

I need to count cells based on a 11th and 12th character in the string.

I tried count, countif, an array formula and all I get is "0".

Example attached.

As always, help is greatly appreciated!

Thanks,
Bond002

[Jonmo1]

It looks like you actually want the 11th and 12th characters, right?

Try
=SUMPRODUCT(--(MID(B2:D6,11,2)="60"))

[bond002]

Thanks Jonmo, worked a treat!

I should probably read up about the sumproduct functions as this is not the first time I came across it!

Cheers,
Bond002