| |||||||||||||||||||||||||||||||||||||||||||||||||
I haveseven columns of data. An eighth column shows the total for the row. I wantto count when A (Ace), K (King) or Q (Queen) occurs in columns 1, 2 and 3 butonly when the eighth column is greater than 3. A canonly occur in column 1 K canoccur in column 1 and 2 Q canoccur in column 1 2 and 3 Can dothe IF parts but hopless when trying to put the AND part in Thanks Peter |