Hello--
I have a lot of sales data, and I want to find out how many sales there are between 10K-50K, 50K-100K, etc. How do I do a COUNTIFS function for greater than/less than? For instance, this is how I think it should look, but this does not work: COUNTIFS(A:A,">10000","<50000").
If anyone has any advice, I would appreciate it. Thanks a lot!
I have a lot of sales data, and I want to find out how many sales there are between 10K-50K, 50K-100K, etc. How do I do a COUNTIFS function for greater than/less than? For instance, this is how I think it should look, but this does not work: COUNTIFS(A:A,">10000","<50000").
If anyone has any advice, I would appreciate it. Thanks a lot!