Excel Formula Question

[ElectricSavant]

I have tried to do this. The best way I think is for me to "learn by example".

If "Execute2" or "Harry" or anybody has time to look at my attached spreadsheet and give me the formula's for C22 and C23, that would be a great help.

If you do not want to spoonfeed me, I understand. Perhaps a hint would put me in the right direction. I am working with counts of a single column with positive and negative numbers, which is perplexing me.

Michael B.

 

[ktm]

Try this:

for C22 =COUNTIF(O4:O7,">=0")
for C23 =COUNTIF(O4:O7,"<0")

 

[ElectricSavant]

Thanks, I see now. Count IF is powerful. I did not realize "if" statements could be in 2 parts (I have always used them to print blank when empty in a statement with 2 commas and 3 parts).

I used the P column and it worked.

Michael B.

Quote from ktm:

Try this:

for C22 =COUNTIF(O4:O7,">=0")
for C23 =COUNTIF(O4:O7,"<0")

 

[ElectricSavant]

Guys. Look at my beautiful spreadsheet!

Could not have done it without you.

Michael B.

P.S. Thanks again ktm

 

[ktm]

Now go make some money!!!

 

[ElectricSavant]

Could you spoonfeed me that too!

Michael B.

Quote from ktm:

Now go make some money!!!

 

[ktm]

I wish. I would get a shovel out and dump some on myself!!!!