Search for ! then sum....

  • Thread starter Thread starter AussieOwl
  • Start date Start date
A

AussieOwl

I have an application that dumps information into a
workbook.

I need to search column A untill I find "!" then in the
adjacent cell in Column B sum all the above cells in
column B untill but not including a cell which contain
numbers & text.

This is then repeated for the rest of the workbook.

Ive tried working with lookup functions but canot get
them to sum correctly.

Any Ideas anyone????
 
in B1

=SUM(A1:OFFSET(A1,MATCH("!",A:A,FALSE)-2,0,1,1))
assumes data in A starts in A1


Patrick Molloy
Microsoft Excel MVP
 
Hi
not quite sure how your data is strutured?. Do you also have values in
column B and a blank cell cell for the sum??. It would be helpful if
you can post some example data rows (plain text please) and your
expected result
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Add sum formula automatically using VBA 3
Couple subs need help with 2
VBA set thick borders around non empty cells in range 0
Copy Formula Down until last row 2
Create if partial match then copy and paste data from one cell to another 1
Vlookup finance help please 14
search for ! then sum... 1

Back
Top