Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 698
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting transactions as listed in reports Daiv Excel Discussion (Misc queries) 1 February 26th 07 12:02 AM
The goal is 5 per 100 transactions, how do I write formula for % andy3468 Excel Discussion (Misc queries) 2 July 11th 06 02:13 PM
couting transactions for same time kdp145 Excel Worksheet Functions 1 December 15th 05 05:50 PM
Finding Matching (ContraSide) Transactions carl Excel Worksheet Functions 2 December 12th 05 07:57 PM
counting with a criteria in multiple transactions shafali Excel Worksheet Functions 1 November 29th 04 02:15 AM


All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"