Try: =SUMIF(1:1,"<W",4:4)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Lee Ann" wrote:
.. How would I capture the totals in the columns which contain no W