A
amorrison2006
Hi
As the subject says
My data is like
Column A Column F
John 100.00
10.00
Total 110.00
Blank Row
Smith 100.00
10.00
Total 110.00
Blank Row
I have two blank rows between every part of my data,
I need to insert a sum formula to sum all the above to the previous
sum formula.
I already tried the edit go to special cells and used the sum button
but it inserted the formula in every blank cell for the column making
my data wrong,
I hope someone can help and I am being clear,
Thanks so much
Andrea
As the subject says
My data is like
Column A Column F
John 100.00
10.00
Total 110.00
Blank Row
Smith 100.00
10.00
Total 110.00
Blank Row
I have two blank rows between every part of my data,
I need to insert a sum formula to sum all the above to the previous
sum formula.
I already tried the edit go to special cells and used the sum button
but it inserted the formula in every blank cell for the column making
my data wrong,
I hope someone can help and I am being clear,
Thanks so much
Andrea