Need formula for these steps

J

jtinne

I need the formula to these steps in order.
step 1: find the date above in the column of the cell the formula is going
in (the location of this date is known)
step 2: use the found date from step 1 and find that same date on sheet 2
(note: the row the date will be in known but the column it is in will need to
be found)
step 3: in the column of the found date from step 2, count the number of
times a specific text appears in that column
step 3: give the total times that text appears in cell

thank you
 
F

Frank Kabel

Hi
try the following:
A1: your date
A2: the following formula:
=COUNTIF(OFFSET('sheet2'!A:A,0,MATCH(A1,'sheet2'!1:1,0)-1),"Text to
search")
 
Top