jasonc310771
09-22-2009, 11:54 AM
i wish to count all columns which have 'P' and the 'a' column has a certain phrase given in the formula.
i.e.
=COUNTIF('Attendance log'!F:F,"P")
counts all 'F:F' that has 'P'
but wish to have this check this way instead
NAMES TABLE COLUMN 'K'
has all the totals but wish to have this formula count all 'P' in the columns for each name
in K2
=COUNTIF( names table: column $A$2 = current table $F$1 ,"P")
i.e.
=COUNTIF('Attendance log'!F:F,"P")
counts all 'F:F' that has 'P'
but wish to have this check this way instead
NAMES TABLE COLUMN 'K'
has all the totals but wish to have this formula count all 'P' in the columns for each name
in K2
=COUNTIF( names table: column $A$2 = current table $F$1 ,"P")