Hello there-
I am trying to do a countif function on a series of data that isn't working properly. The data is organized in three columns:
Basically I want the count if to show me how many payments there are per column based on the days to pay. I tried doing a countifs based on the "Days to Pay" so formula would go something like "Count column A if the days to pay are 0-50, 51-100, etc." However, I keep getting #VALUE ! errors.
Any tips?
Thanks so much!!
I am trying to do a countif function on a series of data that isn't working properly. The data is organized in three columns:
$ HR | $ Biz Dev | $ Marketing | Total | Days to Pay |
25 | 25 | 100 | ||
50 | 50 | 50 | ||
25 | 25 | 50 | 100 | 3 |
60 | 60 | 120 | 20 |
Basically I want the count if to show me how many payments there are per column based on the days to pay. I tried doing a countifs based on the "Days to Pay" so formula would go something like "Count column A if the days to pay are 0-50, 51-100, etc." However, I keep getting #VALUE ! errors.
Any tips?
Thanks so much!!