ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel worksheet problem 2 (https://www.excelbanter.com/excel-discussion-misc-queries/216772-excel-worksheet-problem-2-a.html)

Rocket

excel worksheet problem 2
 
example: ( to day) ( to date) (total )
1 2 3
now if the next entry to ( to day) is 3 & entry to (to date) is 4 the answer
in (total should be 10. 3+3+4 please advise with a working formula.
--
rocket

muddan madhu

excel worksheet problem 2
 
Col A Col B Col C
to day to date total
1 2 3
3 4 10

in cell C3 put this formula
=SUM(A3:B3,C2) and drag it as required



On Jan 17, 12:27*am, rocket wrote:
*example: *( to day) ( to date) *(total )
* * * * * * * * * * 1 * * * * *2 * * * * * * * 3
now if the next entry to ( to day) is 3 & entry to (to date) is 4 the answer
in (total should be 10. 3+3+4 * *please advise with a working formula..
--
rocket




All times are GMT +1. The time now is 09:30 AM.

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