1

I have a column of data in the following general format:

2000
1000
500
300
1500

c
a


1000
1500
1250
3000


4000
6500

3000

1000
1000
1000

f


4500
1500
3000
3000
2000

There is no pattern to the number of entries in each 'block', the number of spaces between blocks, or the number of non-numeric characters between blocks. What I would like to be able to do is sum each of the 'blocks and place the result beside its respective block. Is there a way to do this without VBA?

10

In B2 enter:

=IF(AND(ISNUMBER(A2),NOT(ISNUMBER(A3))),SUM($A$1:A2)-SUM($B$1:B1),"")

and copy down:

enter image description here

  • 1
    You can also use Ctrl-D in Excel to 'Fill Down' if the column is long and you don't want to scroll to find the end to copy down. – jhaagsma Mar 4 '16 at 20:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.