Hi Ragdyer,

The "blocks" of data are completely random: previously downloaded data
sorted chronologically before copying into the workbook, which may contain,
as stated, from 4 to 25 rows, and that's where lies the problem: I don't know
in advance how many rows there will be in each block, hence the manual
counting to set my "total" cells in column Y.
Thanks for the interest
Regards
CAT

"Ragdyer" wrote:

Besides a visual inspection, what determines the size of the block to
calculate?

Your example went down to Row 18, even though Row 11 to 18 was empty.

Need more info.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"CAT" wrote in message
...
Hi everyone, hope you can help me with this one as manually, it's a
lengthy
process!
Using Excell 2007 and though a fairly new user, know my way around:

Worksheet contains 6 columns T, U, V, W, X and Y plus another column AG in
a
small fixed a few columns to the left of the worksheet proper.

Col W contains the formula (copied and pasted right down the col):
=IF(T8="YES",(U8)*V8," ") returns a + figure
Col X contains the formula (copied and pasted right down the col):-
=IF(T8="NO",-V8," ") returns a - figure
Col Y, in one cell appearing only once at the end of a series of rows,
contains the formula: =SUM(W8:W18)+(SUM(X8:X18) returns total of col W+X
for
that block of rows (8 to 18 for ex).
Cols T,U and V are blanks as data is entered and will prompt cols W,X and
Y
to return a value.

Example:
Col T Col U Col V Col W Col X Col Y
Col AG
row 8 blank blank blank blank blank blank
2550
row 9 Yes 30 100 3000 blank blank
500
row 10 No blank 450 blank -450 blank
etc.
row 11 blank blank blank blank blank blank
etc
row 18 blank blank blank blank blank 2550
row 19
etc
etc 500

What I am doing:
copy and paste my formulae in cols W and X; then, manually counting the
rows
in the block, enter the SUM formula in the box in col Y, at the end of the
sequence (which can vary from 4 rows to 25 or more rows); I then make a
note
of the cell row number and, in the static small recap table a few columns
away, enter in, say AG6, = Y18, AG7 = Y25, etc. etc.

What I would like:
To automate the process to make it simpler an easier to handle;
Is there a way that the sum value in both cells, in the Y column and in
the
AG column, could be returned automatically without having to resort to the
manual counting of rows?
Thank you all in advance for your help and input