Help on countif

[JJPPP]

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:

$ 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!!

 

[FDibbins]

something like 0-50 is a text entry, not a numeric, excel would not be able to compare that wit any real values.

Caving said that, I think you need to look at the COUNTIFs() function instead.

=countifs(A:A, ">0", E:E,">=0", E:E, "<=50")