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
 

Some videos you may like

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.

Watch MrExcel Video

Forum statistics

Threads
1,118,436
Messages
5,572,109
Members
412,441
Latest member
kelethymos
Top