Forum Discussion
Formula help
Hi, I have a list of sales in a column and another column that shows if a sale has been cancelled, in this column there are only 2 options Blank and Cancelled. When I choose cancelled I want the ...
As you say, the approaches are broadly the same but, by using array formulas, my approach does not required the helper column, unless you wish to display it. The sum of amounts, for example, can be calculated directly from the data as entered.
Thanks for that. I have used the conditional formatting to alert people to the change in the sales status and will use your formula.
Thank you
Thank you