Excel formula

M

Michelle

I am looking for a formula that will give me an increasing number in a cell
if there is a value (words) in a corresponding cell, and a blank if there is
nothing in the cell. Any ideas?
 
R

Rowan

Hi Michelle

With your data in Column A starting in Row 2. In B2 enter:

=IF(A2="","",SUMPRODUCT(--($A$2:A2<>"")))

and copy down to end of data.

Does this help?

Regards
Rowan
 
A

Aladin Akyurek

Let B3:B7 house

dfa
wqa
=""

xsa

where B5 is "", resulting from a formula and B6 empty.

In A1 enter a 0.

In A2:B2 enter the appropriate headers.

In A3 enter & copy down:

=IF(B3<>"",LOOKUP(9.99999999999999E+307,$A$1:A2)+1,"")

Note that a formula-blank is treated in the same way as an empty cell.
 
M

Michelle

Thank you - that works perfectly, although I don't understand how the
SUMFUNCTION part of it works.
 
Top