Re-post Formula Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this formula: =IF(B11<>"",SUMPRODUCT(--(Events!$A$10:$A$311=B11),--(Events!$B$10:$B$311+E
ents!$C$10:$C$311>='General log'!Y11 + 'General log'!Z11),--ISNUMBER(MATCH(Events!$H$10:$H$311,DownTimeCodes,0)),Events!$N$
0:$N$311),""

It is supposed to look to column H10:H3110 of an Event sheet for values which may match the values in a named range called "DownTimeCodes". When I plug data into the Excel sheet and add the codes that are not in the list (Named Range), I should get no value, this part works. Now, however, when I plug data into the Excel sheet using the codes that are in the list (Named Range), I still get no value. Am I doing something wrong? Or does the formula need a bit more fine tuning? Slightly confused. please, help if you are able to do so. Thanks,.....in advance
 
The codes in DownTimeCodes and the ones in Events!$H$10:$H$311 must exactly
match. Sometimes extraneous spaces around text values are the culprit.

Syd said:
I have this formula:
Click to expand...
=IF(B11 said:
ents!$C$10:$C$311>='General log'!Y11 + 'General log'!Z11),--ISNUMBER(MATCH(Events!$H$10:$H$311,DownTimeCodes,0)),Events!$N$1
0:$N$311),"")

It is supposed to look to column H10:H3110 of an Event sheet for values
Click to expand...
which may match the values in a named range called "DownTimeCodes". When I
plug data into the Excel sheet and add the codes that are not in the list
(Named Range), I should get no value, this part works. Now, however, when I
plug data into the Excel sheet using the codes that are in the list (Named
Range), I still get no value. Am I doing something wrong? Or does the
formula need a bit more fine tuning? Slightly confused. please, help if you
are able to do so. Thanks,.....in advance!
 
Back
Top