Gord,

what is that * 1 for ?

"Gord Dibben" wrote:

=SUM(LEFT(A1),LEFT(A2))*1

Returns 3


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 09:35:02 -0700, Nanou
wrote:

Hi Roger,

Thanks for your help. But as I said I already used the formula and what
happened is that it is bringing me a wronge count. I explain:
Based on the example I posted in my original message it will give me " 2 "
as result for my " DO " count , where it should be " 3" (number of actual
"DO" )

Thanks for any help!



the following result for "do" my example
"Roger Govier" wrote:

Hi

Try
=SUMPRODUCT(--(ISNUMBER(FIND("DO",A1:A100))))
Change range to suit

It might be better to put the "DO" or "DI" in a cell e.g. in C1 , then you
can just use the formula
=SUMPRODUCT(--(ISNUMBER(FIND(C1,A1:A100))))


--
Regards
Roger Govier

"Nanou" wrote in message
...
Here is a sample of my column cells contents:

2DO, 5DI (this data is in one cell)
1DO, 2DI
AI
AO

I need to get a total of "DO", total of "DI" ...etc. separately
I have tried countif, sumproduct...but not getting the right result!

Would appreciate any help.
Yasmina