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

Please Login or Register  to view this content.

Originally Posted by sanram

Or you can try this too

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

work?

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