Quote Originally Posted by chullan88 View Post
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?