![]() |
#1
|
|||
|
|||
![]()
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(D4 ![]() =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 |
#2
|
|||
|
|||
![]()
Please attach the sheet.
|
![]() |
Tags |
countif, formulas, if formula |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word Mixing Numbered Headings with Numbered List | Tess0 | Word | 11 | 07-15-2014 05:25 AM |
![]() |
Friday | Word | 2 | 11-29-2013 08:10 PM |
![]() |
trew | Word | 7 | 11-21-2012 12:54 AM |
Mixing Landscape and Portrait Slides in one presentation | bluespete | PowerPoint | 0 | 10-13-2011 05:39 AM |
![]() |
mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |