Forum Discussion
Keggsy
May 11, 2020Copper Contributor
Combining countif with more than one parameter and cells with no value
Hi all, I’m hoping you can help please. I am looking to combine two countif cells into one if possible please? I currently have some data, where the first countif counts the number of values in a col...
Lewis-H
May 11, 2020Iron Contributor
If there are more than two criteria that you want to count in one column, just use =COUNTIF(range1, criteria1) + COUNTIF(range2, criteria2) + COUNTIF(range3, criteria3)+…