Can you explain that, it doesn't work for me?
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"CaptainQuattro"
<CaptainQuattro.277voy_1146635100.8876@excelforu m-nospam.com wrote in
message news:CaptainQuattro.277voy_1146635100.8876@excelfo rum-nospam.com...
Here's a workaround that will work in any version of Excel:
In row 1 Column D enter =CELL("width",A2)
Copy to cells E1 through K1
in Cell L11 enter
=SUMIF(D1:K1,"0",D11:K11)
--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile:
http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=537953