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...
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?
You wrote back to Patrick2788 not sure I understand the #name?
Which suggests to me that the formula he provided you requires a newer version of Excel than you have. LAMBDA is a very new feature.
In this attached spreadsheet, I get the same results with a tried and true formulation, using SUM. You do need to copy it down the various rows of the column. I left the solution by Patrick2788 in place; it is elegant, and worth studying if/when you update your Excel software.
- in the column received to date has #name?...not sure I understand what I should formulate???
