Excel Forum

Excel Magic Trick # 269: COUNTIF & Ampersand

See how to get criteria from four (4) different cells and combine (join) them into one criterion for the COUNTIF function. See how to use the COUNTIF function and the Ampersand to count the number of items that match from a sample.

Count with criteria condition.

Got a Question? Ask it Here in the Forum.