Counting Multiple options

So i have a worksheet that we use to track if an ad has deployed that week for each client we put an x if it deployed, more than once we put 2 x's.
I need to count the total number of "x" and "xx" in a single row so far I have only figured out how to count a single "x" by using =COUNTIF(D3:AS3,"X") but i also need to include the "XX" and those need to have a value of 2.
So single x=1, xx=2 sum of these does this make sense.

Thanks for your help
BabyBandit82

Or you can try this too

=SUMPRODUCT(LEN(D3:AS3)-LEN(SUBSTITUTE(D3:AS3,"X","")))

Originally Posted by sanram

Or you can try this too

=SUMPRODUCT(LEN(D3:AS3)-LEN(SUBSTITUTE(D3:AS3,"X","")))

Hi,

A small modification of sanram's formula works well

={SUM(LEN(D3:AS3)-LEN(SUBSTITUTE(D3:AS3,"x","")))}

Entered as an array formula.

Originally Posted by chullan88

Hi,

A small modification of sanram's formula works well

={SUM(LEN(D3:AS3)-LEN(SUBSTITUTE(D3:AS3,"x","")))}

Entered as an array formula.

It is an array formula. But not mine. Didn't that

=SUMPRODUCT(LEN(D3:AS3)-LEN(SUBSTITUTE(D3:AS3,"X","")))

work?

Thanks FlameRetired that worked you guys saved me a lot of time.