COUNTIFS function

H

hfler

Board Regular
Joined
Jun 10, 2008
Messages
95
Hello--

I have a lot of sales data, and I want to find out how many sales there are between 10K-50K, 50K-100K, etc. How do I do a COUNTIFS function for greater than/less than? For instance, this is how I think it should look, but this does not work: COUNTIFS(A:A,">10000","<50000").

If anyone has any advice, I would appreciate it. Thanks a lot!
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
I do not know how to use the COUNTIFS function, but I would use a sumproduct for this.

=SUMPRODUCT(--(A1:A10000<50000),--(A1:A10000>10000))

If you use Excel2007, then you can use EntireColumn references (A:A) in place of A1:A10000.
 
Upvote 0
One possible solution - set up another column :-

B1=if(and(a1>10000,a1<50000),1,0)

and then sum the values in Column B.

HTH

Kaps
 
Upvote 0
one way ...

<html><head><title>Excel Jeanie HTML</title></head><body>
Excel Workbook
ABCD
19000GreaterThanLessThanOrEqualToCounnt
21300010000500006
317000500001000003
421000***
525000***
629000***
753000***
869000***
999000***
10120000***
1149000***
Sheet13_Jeanie


</body></html>
 
Upvote 0
You must log in or register to reply here.

Similar threads

F
  • Question
Enhance COUNTIFS formula to search for text in a string as part of the criteria
Replies
2
Views
342
freeb1893
F
M
  • Solved
COUNTIF to count cells with conditional formatting
Replies
8
Views
330
Peter_SSs
Peter_SSs
carpetony
  • Solved
CountIf across columns, as an array functions, not concatenated.
Replies
2
Views
166
Eric W
Eric W
D
  • Solved
Help with duplicates
Replies
7
Views
209
awoohaw
awoohaw
T
  • Solved
VBA to Deselect PivotFields Values if it exists
Replies
6
Views
544
Alex Blakenburg
A

Forum statistics

Threads
1,214,592
Messages
6,120,433
Members
448,961
Latest member
nzskater

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top