#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default needed formula

i need to know a formula to calucalte by addition rows by columns. Example
row 5, B-K + row 15, B-K. Each equaling the added value per column. This is
calculating YTD's per month across the board without doing each individually
like =SUM(L459,L507)

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default needed formula


Not sure I have it straight what you're doing, but maybe something like
this:

=SUM(B5:K5) + SUM(B15:K15)


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61700

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
Formula Needed Oscar A. Brown Excel Worksheet Functions 9 January 31st 09 04:06 AM
Excel formula to copy/paste formula needed please. colwyn Excel Discussion (Misc queries) 4 October 22nd 08 11:27 PM
formula needed please jackrobyn1 Excel Discussion (Misc queries) 2 June 5th 08 11:50 AM
IF AND Formula Help Needed Karen Smith Excel Discussion (Misc queries) 8 December 17th 07 07:09 PM
Formula Needed Cheryl Garst Excel Discussion (Misc queries) 3 September 1st 06 07:53 PM


All times are GMT +1. The time now is 11:14 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"