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

countif/sumif question
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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

countif/sumif question
 

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

thanks.

--


Gary


"Don Guillett" wrote in message
...
try
=COUNTIF(P$3:P$33,"*M*")
you may? not get desired results

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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

countif/sumif question
 

maybe an array formula?


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


--
Hope that helps.

Vergel Adriano


"Gary Keramidas" wrote:

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

thanks.

--


Gary


"Don Guillett" wrote in message
...
try
=COUNTIF(P$3:P$33,"*M*")
you may? not get desired results

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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

countif/sumif question
 

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

--


Gary


"Vergel Adriano" wrote in message
...
maybe an array formula?


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


--
Hope that helps.

Vergel Adriano


"Gary Keramidas" wrote:

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

thanks.

--


Gary


"Don Guillett" wrote in message
...
try
=COUNTIF(P$3:P$33,"*M*")
you may? not get desired results

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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

countif/sumif question
 

this seems to work for me, thanks

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

--


Gary


"Vergel Adriano" wrote in message
...
maybe an array formula?


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


--
Hope that helps.

Vergel Adriano


"Gary Keramidas" wrote:

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

thanks.

--


Gary


"Don Guillett" wrote in message
...
try
=COUNTIF(P$3:P$33,"*M*")
you may? not get desired results

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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