Finding text in one field, and then totally another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

every few rows, I have a Daily totals text in column D. The column E has a
calculated number. I want to find the Daily Totals rows and add the numbers
in the corresponding E column to get all the totals. How do to?
 
Are your formulae in column E of the form:

=SUM(start_cell:end_cell)

where you are adding the numbers (also in column E) from a few rows
above?

If so, then highlight column E by clicking on the column identifier
and do CTRL-H (Find & Replace) to:

Find What: SUM(
Replace With: SUBTOTAL(9,

then click Replace All. Now if you want to add the subtotals in column
E together, you can enter this formula somewhere:

=SUBTOTAL(9,E1:E1000)

(for example - adjust the range to suit).

Hope this helps.

Pete
 
Back
Top