#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default cells

Ok, I need to add some cells together. They are numbered by buildings for the
cell and 2 buildings are in the same cell. How do I add them together, along
with the rest of the cells? ex: I did =J66+J66+J32
I need them to plus, plus, plus.. even though it's in the same cell.. does
this make sense? I need help... PLEASE!!!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,510
Default cells

Don't really understand the question. Can you post an example of the data in
each of the cells J66 and J32 plus an example of what you want the output to
be.

Also in what cell do you want the output?


--
Regards,

OssieMac


"adding cells" wrote:

Ok, I need to add some cells together. They are numbered by buildings for the
cell and 2 buildings are in the same cell. How do I add them together, along
with the rest of the cells? ex: I did =J66+J66+J32
I need them to plus, plus, plus.. even though it's in the same cell.. does
this make sense? I need help... PLEASE!!!

  #3   Report Post  
Posted to microsoft.public.excel.charting
dsm dsm is offline
external usenet poster
 
Posts: 6
Default cells

It's not clear exactly what you are asking, but I suspect you should read up
on the SUMPRODUCT() function.

"adding cells" wrote:

Ok, I need to add some cells together. They are numbered by buildings for the
cell and 2 buildings are in the same cell. How do I add them together, along
with the rest of the cells? ex: I did =J66+J66+J32
I need them to plus, plus, plus.. even though it's in the same cell.. does
this make sense? I need help... PLEASE!!!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: match two cells in one sheet to two cells in another and return a third cells value Spence Excel Worksheet Functions 3 February 13th 11 05:33 AM
Cells won't change font color or show hi-lighted cells in document ROBIN Excel Discussion (Misc queries) 1 March 27th 08 09:39 PM
display a range of cells editible cells based on matching date Miki Excel Worksheet Functions 0 October 10th 07 03:27 PM
Setting of input cells as blue font and formula cells as black fon Sunnyskies Excel Discussion (Misc queries) 2 May 14th 07 05:27 PM
trying to create an (almost) circular formula between cells and data validated cells with lists KR Excel Worksheet Functions 0 May 12th 05 07:21 PM


All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"