I want to count range that satisfies more than one criteria using the countif function.
P Perin Dec 7, 2005 #1 I want to count range that satisfies more than one criteria using the countif function.
B Bob I Dec 7, 2005 #2 You will need to do multiple countif's, and add or subtract them as in Countif(range,first criteria)-Countif(range,not second critera)
You will need to do multiple countif's, and add or subtract them as in Countif(range,first criteria)-Countif(range,not second critera)
