Hi , since you seem to be an Excel Guru, i've a question that you may be able to answer. is there a formula that add to something while keeping a previous calculation? Let me explain what i'm looking for: Let's say i have in cell A1 a value "100,00 hr" & in cell A2 "1,50 hr" (using decimal values with suffix, not hours / time / duration) (meaning 1.50 hr instead of 1:30:00) I want A1 to sum the added value every time i add something in A2. Let's say monday i add 1,50 hr on A2, i want A1 100,00 hr to be be "101,50 hr" Tuesday i write 2,00 hr in cell A2, i want it to sum up in A1 ( "103,50 hr") Wednesday i write 5,00 hr in cell A2, i want it to keep summing in A1 ( = 108,50 hr) etc. First of all, is it possible to do this? and if it is, what would be the formula? To be even more spécific i'm gonna use it on Google Sheets, hopefully , if there's a formula on Excel, Google Sheets will deal with it. Thanks a million.
Excellent Chester. Knowing this is essential in Excel. Good explanation.
Glad you think so!
Hi , since you seem to be an Excel Guru, i've a question that you may be able to answer.
is there a formula that add to something while keeping a previous calculation?
Let me explain what i'm looking for:
Let's say i have in cell A1 a value "100,00 hr" & in cell A2 "1,50 hr" (using decimal values with suffix, not hours / time / duration)
(meaning 1.50 hr instead of 1:30:00)
I want A1 to sum the added value every time i add something in A2.
Let's say monday i add 1,50 hr on A2, i want A1 100,00 hr to be be "101,50 hr"
Tuesday i write 2,00 hr in cell A2, i want it to sum up in A1 ( "103,50 hr")
Wednesday i write 5,00 hr in cell A2, i want it to keep summing in A1 ( = 108,50 hr)
etc.
First of all, is it possible to do this? and if it is, what would be the formula?
To be even more spécific i'm gonna use it on Google Sheets, hopefully , if there's a formula on Excel, Google Sheets will deal with it.
Thanks a million.
How do i exclude multiple text