Moving values from one colum to another when there is spaces betwe
I assume thisis your situation
Cell Value
A1 1
A2
A3
A4 2
A5
A6
A7 3
A8
A9
A10 4
And you want the sum of only those cells where there is a number. Try the
below formula, hope it works-
=SUMIF(B1:B10,"<""",B1:B10)
--
Pranav Vaidya
VBA Developer
PN, MH-India
"Lii Hadin" wrote:
Hi,
I have a real situation here. I have one colum with values on every forth
row. Now, I want to make another colum where the values from the first column
is added, when added in the first coulumn, WITHOUT the spaces.
This is obviously impossible and after trying every function in the program
I really need help here.
Thanks a lot in advance!
BR
Lii Hadin
|