ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   needed formula (https://www.excelbanter.com/excel-worksheet-functions/220134-needed-formula.html)

ez3zz

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)


JBeaucaire[_116_]

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



All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com