=SUMPRODUCT(('WELD LOG'!$F$8:$F$2043="SW")*(ISNUMBER(SEARCH(C15,'WELD
LOG'!$H$8:$K$2043))))


"Jude Reason" wrote:

Hello folks I have a formula here that works in another work book just fine
the only difference in these two formulas is the column that they reference
and these {} symbols when I click on the cell that they represent. here is
the formula.
=SUM(IF('WELD LOG'!$H$8:$H$2043=C15,IF('WELD
LOG'!$F$8:$F$2043="SW",1,0)))+SUM(IF('WELD LOG'!$I$8:$I$2043=C15,IF('WELD
LOG'!$F$8:$F$2043="SW",1,0)))+SUM(IF('WELD LOG'!$J$8:$J$2043=C15,IF('WELD
LOG'!$F$8:$F$2043="SW",1,0)))+SUM(IF('WELD LOG'!$K$8:$K$2043=C15,IF('WELD
LOG'!$F$8:$F$2043="SW",1,0)))
also where the "SW" is substitute that with "WOL"
also in about 5 cells the #value shows up and the rest of the cells just
show up 0.
Like I said in the other workbook this formula works fine. I would
appreciate any help as I have pretty much exhausted myself trying to figure
this one out.
--
Jude Reason
CWI #06041451