IF statement thats Adds

Solved/Closed

bob2011 Posts 8 Registration date Thursday April 8, 2010 Status Member Last seen April 26, 2010 - Apr 26, 2010 at 07:49 AM
bob2011 Posts 8 Registration date Thursday April 8, 2010 Status Member Last seen April 26, 2010 - Apr 26, 2010 at 09:28 AM

Dear All,

I would like to create an If statement which returns a 1 if a cell is greater than 0, then look at the next cell and do the same. Then add all the 1's together and return a number which adds all the 1's together after looking at all the cells.

Can anybody provide a formula which will do this ? Thanks

IF statement thats Adds
Fenix internet on bank statement - Guide
An if statement nested within another if statement will produce how many possible results? - Guide
Excel if statement - Guide
Application for bank statement sbi - Guide
Vba case statement with string - Guide

2 responses

Answer 1 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 26, 2010 at 08:14 AM

There is a lot of ambiguity in your question. Since you have not mention where this "next cell" is, I am presuming it is on same column but next row.

Let say

A2 and A3 are two cells that are to be looked for

=IF(A2>0, 1) + IF(A3>0,1,0)

Answer 2 / 2

bob2011 Posts 8 Registration date Thursday April 8, 2010 Status Member Last seen April 26, 2010
Apr 26, 2010 at 09:28 AM

i have solved what i was looking for.

the correct formula was:

=COUNTIF(C31:C58,">0")

thanks for your help anyway.

Similar discussions

Ig stories from close friends to public

Do users get notified when I add them to a group?

Removing " false" value in "IF"

If a cell contains any text then add a value

Need help to remove FALSE from cell

Similar discussions

Subscribe To Our Newsletter!