Finding text in one field, and then totally another
 

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?

Finding text in one field, and then totally another
 

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 somewhe

=SUBTOTAL(9,E1:E1000)

(for example - adjust the range to suit).

Hope this helps.

Pete

On Apr 26, 11:16 pm, Tom D wrote:
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?