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:

[TABLE="width: 500"]
[TR]
[TD]$ HR[/TD]
[TD]$ Biz Dev[/TD]
[TD]$ Marketing[/TD]
[TD]Total[/TD]
[TD]Days to Pay[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD][/TD]
[TD][/TD]
[TD]25[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]50[/TD]
[TD][/TD]
[TD]50[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]25[/TD]
[TD]50[/TD]
[TD]100[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]60[/TD]
[TD]60[/TD]
[TD]120[/TD]
[TD]20[/TD]
[/TR]
[/TABLE]

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")