Excel: count on cell value 2

[jgurgen]

im trying to keep a count on how many cells have M, F or LOA

=IF(I7:EI7="M",COUNTIF(I7:EI7,"M"), IF(I7:EI7="F", COUNTIF(I7:EI7, "F")), IF(I7:EI7="LOA", COUNTIF(I7:EI7, "LOA")))

 

[Lilliabeth]

I am not sure what range you are trying to use, but maybe this will help

=COUNTIF(E7:I17,"loa")+COUNTIF(E7:I17,"f")+COUNTIF(E7:I17,"m")

 

[SkipVought]

hi,
[tt]
=countif($I$7:$E$I7,"M")+countif($I$7:$E$I7,"F")+countif($I$7:$E$I7,"LOA")
[/tt]


Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}

 

[jgurgen]

worked but the range was i7 to ei7