Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting transactions as listed in reports | Excel Discussion (Misc queries) | |||
The goal is 5 per 100 transactions, how do I write formula for % | Excel Discussion (Misc queries) | |||
couting transactions for same time | Excel Worksheet Functions | |||
Finding Matching (ContraSide) Transactions | Excel Worksheet Functions | |||
counting with a criteria in multiple transactions | Excel Worksheet Functions |