# countif formula

#### aysam

##### Board Regular
Hi all
I need a COUNTIF formula
Range: A10:BB10
Criteria : more than 7 and less than or equal to 10
Is it possible ?

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Try:

=COUNTIFS(A10:BB10, ">7", A10:BB10, "<=10")

HTH,
~ Jim

Hi jam
I'm using Excel 2003
There's no countifs formula

try using: =sumproduct(--(A10:BB10>7),--(A10:BB10<=10))

=SUMPRODUCT(--(A10:BB10 > 7), --(A10:BB10 <= 10))

Cheers,
~ Jim

Jim
Storm925
Thanks very much
That works well

Replies
2
Views
120
Replies
5
Views
490
Replies
1
Views
154
Replies
4
Views
144
Replies
1
Views
157

1,196,057
Messages
6,013,176
Members
441,751
Latest member
336448

### 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.

### Which adblocker are you using?

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

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