You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Snit" wrote in message
...

Thanks guys for all of your suggestions. I tried T. Valko;2711118]Try
this:

=SUMPRODUCT(--(MOD(ROW(C8:C20),4)=0),LEN(C8:C20)-LEN(SUBSTITUTE(C8:C20,"D","")))
and it worked out perfectly. All I had to do was change the ending
cell.

Thanks T. Valko and the rest of you.


T. Valko;2711118 Wrote:
Try this:

=SUMPRODUCT(--(MOD(ROW(C8:C20),4)=0),LEN(C8:C20)-LEN(SUBSTITUTE(C8:C20,"D","")))

--
Biff
Microsoft Excel MVP


"Snit" wrote in message
...-

Does anyone know how to simplify the following eqution in Excel?


=SUM(LEN(C8)-LEN(SUBSTITUTE(C8,"D","")))/LEN("D")+SUM(LEN(C12)-LEN(SUBSTITUTE(C12,"D","")))/LEN("D")+SUM(LEN(C16)-LEN(SUBSTITUTE(C16,"D","")))/LEN("D")+SUM(LEN(C20)-LEN(SUBSTITUTE(C20,"D","")))/LEN("D")

Thanks for the help.




--
Snit -




--
Snit