CountIf Trouble (1 Viewer)

[123James]

I am using count if on a range of cells containing single letters eg. C

I can use countif to look for 'greater than' or 'less than' another letter but how do i count letters between a range. ie. count cells containing a letter between C and H?

Thanks

 

[shades]

That is two conditions, so use SUMPRODUCT.

=SUMPRODUCT(($A$1:$A$10>="C")*($A$1:$A$10<="H"))
________
LINCOLN-ZEPHYR V12 ENGINE SPECIFICATIONS