View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pranav Vaidya Pranav Vaidya is offline
external usenet poster
 
Posts: 180
Default 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