If and sum function

[sruban]

Hi there,

I looking for formula for a solution as below:

If cell b2 is empty do nothing, if cell b2 contains anything then sum cell a2.
Entire column A:A is empty too.

Basically this if for numbering
Column A
exm 1 (if b2 contains anything)
- (if b3 contains nothing)
2 (if b4 contains anything)
- (if b5 contains nothing)
3 (if b6 contains anything)

[Olly]

It sounds like you're asking for:

Please Login or Register  to view this content.

But this will return a blank value, if column A:A is empty? It's not entirely clear what you want!

[kvsrinivasamurthy]

IN A2 , then drag down.
=IF(B2="","",MAX($A$1:$A1)+1)