LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cat Cat is offline
external usenet poster
 
Posts: 63
Default function returning SUM of 2 adjacent cols in 2 separate cells

Hi Max,
Sorry again, I hadn't read your preceding reply. The reason I did not press
Yes is because of the unsolved part 1 of my query. I will wait a little and
if I don't get an answer, will close this thread and start another whilst
trying to clarify things a bit.
Thank you again.

"CAT" wrote:

Hi Max,
I'm new here; so apologies for the "error of conduct". I actually posted on
General and did not get an answer as such, but a need for more info, so I
thought that posting my query on Functions would get me somewhere.
I just wanted to say a big thank you for your answer by the way: I have just
applied your formulae to my present workbook, filled in the Y cells manually
and it WORKS - Every totals are returned in neat order in my checkup table,
including the header of col Y! Thank you again for your help.
Any chance of resolving part 1 of my query?
Sorry to be so demanding!

"Max" wrote:

Ah, I just realized that you posted a similar question in .misc, and you've
got response there as well. Pl refrain from doing this "multi-posting". Stick
to one posting in one particular newsgroup. Most of the regular responders
will read the popular newsgroups (such as this, .misc & .newusers) so you
won't lose out catching their attention by posting only once in one of these
newsgroups.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:57
xdemechanik
---

 
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
cell returning totals of 2 cols+ sending this value to another col CAT Excel Discussion (Misc queries) 5 September 30th 08 08:51 PM
Returning adjacent values chris miller Excel Discussion (Misc queries) 2 March 28th 08 01:57 AM
SUM function won't allow more than 30 non-adjacent cells juanfranela Excel Worksheet Functions 4 April 27th 07 05:12 PM
How to use SUMIF function with non-adjacent cells KLaw Excel Worksheet Functions 5 October 19th 06 10:15 AM
Cond Format:re color 2 cols, skip 2 cols Tat Excel Worksheet Functions 2 June 22nd 05 06:43 PM


All times are GMT +1. The time now is 08:39 AM.

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

About Us

"It's about Microsoft Excel"