# Formula help

Status
Not open for further replies.

#### sitelbanat

##### Board Regular
=COUNTIF(O69:O82,">0")-SUMPRODUCT(--(O69:O82>0),--(ISNUMBER(E69:E82)),E69:E82)

Can anyone help me change this formula so it would
Count how many values in between O69:O82, for example it counts 5,

O69 = 2356
O72 = 2366
O75 = 5456
O80 = 5478
O81= 4578

E 69 = 0.8 since there is a value in O69

the answer should be 4.8 because I want to add the opposite of 0.8 to the total count

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### NBVC

##### Well-known Member
Thanks Brian.

This is why posters should stick to one thread per topic (or revisions to the topic) since it would be easier to follow the "story" or project and perhaps even the person who gave the solution to the original question would easily understand what the OP might really be asking for and come to a quick new solution.

#### Von Pookie

##### MrExcel MVP
Status
Not open for further replies.

Replies
2
Views
139
Replies
7
Views
147
Replies
17
Views
515
Replies
1
Views
316
Replies
1
Views
61

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,809
Messages
5,833,790
Members
430,233
Latest member
cbutts

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