countif/sumif question

[Gary Keramidas]

just wondering if there is a way to use these with the trim function.

=COUNTIF(P$3$33,"M")

so that it would work if the range contains a space or spaces along with the
letter M.

 

[Don Guillett]

try
=COUNTIF(P$3$33,"*M*")
you may? not get desired results

 

[Gary Keramidas]

seems to work. only other alternative is to use a selection change event to fix
the entries.

thanks.

 

[Guest]

maybe an array formula?


=SUM(IF(EXACT(TRIM(P$3$33), "M"), 1, 0))

 

[Gary Keramidas]

i'll give it a try when i get back in.

 

[Gary Keramidas]

this seems to work for me, thanks

=SUM(IF(EXACT(TRIM(P$3$33), "M"),G$3:G$33,0))