Forum Discussion
formula is not adding
What would be the formula to enter in order to add column C8 to and have d8 accumulate D8? and keep adding for example if work 70 hours first week to date c8 and d8 would represent hours worked to da...
Something like this maybe?
=SCAN(0,CumulativeHours,LAMBDA(a,b,a+b))
Please see attached workbook.
- thank you Patrick...I want to create a spreadsheet that would represent a cheque stub this would alway have a column that would indicate the hours work up to and including the week cheque is issued for ....the info on the stub/spreadsheet would also have the money paid to date...column A would be amount received but column b would be the amount received to date,
This workbook is setup with Column A as Received, Column B as Received to date. The formula is in B and a dynamic named range is used to expand/contract the total as needed.
- not sure I understand the #name?
