Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula & Cell #s
I have a client with a table that she is trying to do a formula in. Problem
is that there are merged cells, split cells and all kinds of stuff. How can I find out what the cell number is to put in the formula? I can't just use the =sum(above) command. Basically she has (if these were the right cell #s, but they aren't)... In cell D25 =sum(D23+D24) In cell D27 =sum(D25+D26) So if I use the =sum(above) in D27 it adds them all up. HELP!!! THANKS!!! |
#2
|
|||
|
|||
I'm replying to myself. I downloaded the macro to view the cell numbers and
it told me C23 through C27, so I went to formula =sum(c23+c24) and it says syntax error. Then I put =sum(c23:c24) and it worked. Sorry to bother y'all. "Carla" wrote: I have a client with a table that she is trying to do a formula in. Problem is that there are merged cells, split cells and all kinds of stuff. How can I find out what the cell number is to put in the formula? I can't just use the =sum(above) command. Basically she has (if these were the right cell #s, but they aren't)... In cell D25 =sum(D23+D24) In cell D27 =sum(D25+D26) So if I use the =sum(above) in D27 it adds them all up. HELP!!! THANKS!!! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to Sum values in word table | Mailmerge | |||
How to wrap text from cell to cell in a table. | Tables | |||
Adding formula in the cell | Tables | |||
Word 2003 Table cell formula | Tables | |||
I need a formula of amount of hours from two times in two cell? | Tables |