P
PlutoNash
I need to count up everytime a Y appears in a cell in column I ('Data
Sheet'!I:I) but only when a cell contains a 3 in column F. This is one of the
many variations I have tried. The trouble is, it counts ALL the Y's in column
I instead of only those where a 3 is contained in a cell in column F.
=IF(AND('Data Sheet'!F4=3,'Data Sheet'!I3="Porosity"), COUNTIF('Data
Sheet'!I:I,"Y"))
I would really appreciate some help for a newbie if possible.
ATB.
Sheet'!I:I) but only when a cell contains a 3 in column F. This is one of the
many variations I have tried. The trouble is, it counts ALL the Y's in column
I instead of only those where a 3 is contained in a cell in column F.
=IF(AND('Data Sheet'!F4=3,'Data Sheet'!I3="Porosity"), COUNTIF('Data
Sheet'!I:I,"Y"))
I would really appreciate some help for a newbie if possible.
ATB.