Replace Letter "E" with Letter "C" for 200 Different Sums in a Col

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

Guest

Hi,

I have a series of different sums in the same column which contain the
correct row numbers but not the correct column letter (they contain "E" when
I want them to say "C"; e.g. =SUM(E10:E13) instead of =SUM(C10:C13)). Rather
than going through them one by one manually, is there a quick way to change
all the sums in that column to say "C" with their respective row numbers?

Thank you,
Katherine
 
Hi Katherine
Use Find and Replace for this problem.
If the formula is the same all the way down the column, say A1+B1, A2+B2,
etc, just change the first one then drag the new formula down as far as
required.

HTH
Michael
 
You must log in or register to reply here.

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

Summing a range of cells based on criteria in another range 2
Count the letters in the cells and sum in another cell 1
How to add (sum) a row cells with letter 12
Sum of different value in different worksheet & cell number 2
Sum If on multiple columns with range of criteria 1
Conditional Formula with Words and different columns 5
function returning SUM of 2 adjacent cols in 2 separate cells 7
Copy paste data from a column to a row 0

Back
Top