Try this.
=SUMPRODUCT(--(sheet!$D$2:$D$1191="DO"), --(sheet!$V$2:$V$1191="DI Leader"))

Change the word SHEET to the tab/sheet name you are referencing from.
Hope this helps.
--
Miss Kitty


"Nanou" wrote:

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