# Formula Help

#### missaimee

##### Board Regular
I am trying to find how many items exist between 76.5% and 84.5% on another sheet and I can't get my formula to work. Can someone tell me what is wrong with this formula?

=COUNTIF(Count!E4:I2647,">=76.5""<84.5")

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

#### barry houdini

##### MrExcel MVP
You can't use 2 criteria like that with COUNTIF, here's one way...

=SUMPRODUCT(--(Count!E4:I2647>=.765),--(Count!E4:I2647<.845))

note:edited for percentages...

#### missaimee

##### Board Regular
what do the -- mean? i've never seen those in a formula before

#### missaimee

##### Board Regular
wow, that's great info, thanks!!

#### Scott Huish

##### MrExcel MVP
Another possibility:

=COUNTIF(Count!E4:I2467,">=0.765")-COUNTIF(Count!E4:I2467,">=0.845")

Replies
1
Views
378
Replies
3
Views
326
Replies
2
Views
299
Replies
9
Views
320
Replies
5
Views
701

1,171,245
Messages
5,874,634
Members
433,063
Latest member
Greg_77140

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