Count transactions below a threshold
 

Hi, I need help again...

I am trying to set up a formula that will count the number of transactions
below a certain threshold amount based on a number typed into another cell. I
made it this far...

=COUNTIF('Shipment Detail'!$K$6:$K$44473,"<=A41")

.....What I want to do is for the formula to look at the number I type in A41
and count the transactions <= the amount in A41. However, when I try the
formula above it returns a 0 because the COUNTIF needs a T/F condition.

Ideas? Thanks in advance!

Count transactions below a threshold
 

You were actually pretty close

Try this:

=COUNTIF('Shipment Detail'!$K$6:$K$44473,"<="&A41)

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"dzd&confused" wrote:

Hi, I need help again...

I am trying to set up a formula that will count the number of transactions
below a certain threshold amount based on a number typed into another cell. I
made it this far...

=COUNTIF('Shipment Detail'!$K$6:$K$44473,"<=A41")

....What I want to do is for the formula to look at the number I type in A41
and count the transactions <= the amount in A41. However, when I try the
formula above it returns a 0 because the COUNTIF needs a T/F condition.

Ideas? Thanks in advance!

Count transactions below a threshold
 

PERFECT!!!!!!!!!!!!!!!

THANKS!!

"Ron Coderre" wrote:

You were actually pretty close

Try this:

=COUNTIF('Shipment Detail'!$K$6:$K$44473,"<="&A41)

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"dzd&confused" wrote:

Hi, I need help again...

I am trying to set up a formula that will count the number of transactions
below a certain threshold amount based on a number typed into another cell. I
made it this far...

=COUNTIF('Shipment Detail'!$K$6:$K$44473,"<=A41")

....What I want to do is for the formula to look at the number I type in A41
and count the transactions <= the amount in A41. However, when I try the
formula above it returns a 0 because the COUNTIF needs a T/F condition.

Ideas? Thanks in advance!