IF statement thats Adds
Solved/Closed
bob2011
bob2011
- Posts
- 8
- Registration date
- Thursday April 8, 2010
- Status
- Member
- Last seen
- April 26, 2010
bob2011
- Posts
- 8
- Registration date
- Thursday April 8, 2010
- Status
- Member
- Last seen
- April 26, 2010
Related:
- IF statement thats Adds
- How to use an IF statement to add 1 to total - Guide
- Formula to add 1 with IF statement ✓ - Forum - Excel
- Creating IF statement to filter and ADD. ✓ - Forum - Office Software
- How to add signature in thunderbird - Guide
- How to add filters to videos on snapchat - Guide
2 replies
rizvisa1
Apr 26, 2010 at 08:14 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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)
Let say
A2 and A3 are two cells that are to be looked for
=IF(A2>0, 1) + IF(A3>0,1,0)
bob2011
Apr 26, 2010 at 09:28 AM
- 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.
the correct formula was:
=COUNTIF(C31:C58,">0")
thanks for your help anyway.