View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default countif/sumif question

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

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

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


Gary