Formula help

Status
Not open for further replies.

sitelbanat

Board Regular
Joined
Oct 17, 2005
Messages
152
=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

Then add the opposite

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
Joined
Aug 31, 2005
Messages
5,828
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.
 
Status
Not open for further replies.
Master Excel Bundle

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.

Forum statistics

Threads
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.
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
Top