G
Guest
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!
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!