ExcelBanter - COUNTIF / AND functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - COUNTIF / AND functions (https://www.excelbanter.com/excel-programming/413690-re-countif-functions.html)

Geoff ML[_2_]

COUNTIF / AND functions

the COUNTIF and AND functions are already combined for you in the COUNTIFS
function.

COUNTIFS(range1, criteria1, range2, criteria2, etc). it will only count the
number of times that all conditions are met at the same time.

i'm no expert but hope that helps took me a while before i figured that out
too.

All times are GMT +1. The time now is 05:25 PM.