Hi,

I know i'm near to the goal formula, but got stuck. I have a chart-1 with date, field number, zones (from 1 to 13), and other columns that don't matter to the formula. Aside, chart-2 that depends on the data from chart-1, that will read, range on column B "field number", looking for specific land number, and column's C - O "Zones" 1-13 , looking for an "X". The formula i have use is the fallowing: =IF(AND(COUNTIF(B4:B19,"327N")>0,COUNTIF(C4:C19,"X ")>0),1,"")
=IF(AND(COUNTIF(B4:B19,"327-N")>0,COUNTIF(D419,"X")>0),2,"")
=IF(AND(COUNTIF(B4:B19,"327-N")>0,COUNTIF(E4:E19,"X")>0),3,"")
etc, etc, each formula are on different cells on chart-2.

I want to add that, when "327-N" is found in the first countif on column range B, the next countif in column "C", "D", "E", etc, etc, joust apply on the rows where "327-N" was found.

Any help will be appreciated


Thanks in advanced

Please attach the sheet.