Forum Discussion
SUMIF or Vlookup - count/sum the number of times based on unique values?
I would like to create a formula that counts how many times a condition appears based dates. For example in my example below, I want to the result to be 2 since Bob appears on separate dates 2
How many times does Bob appear on separate dates?
Sheet 1
Bob is in A2
Sheet 2,
Bob is in A and the dates are in B
Bob 10/1/2019
Bob 10/1/2019
Bob 10/1/2019
Bob 10/5/2019
11 Replies
Try this.
Looks like the ranges have to be set which won't work for me as I'm always adding new items . Can A:A and B:B not work?
Entire column references are not recommended in arrays. It will tax Excel.
You can make the ranges longer than needed and it will work OK.
