Hi,
I am looking for a simple formula that adds us the number of changing columns defined in Cell A1
For example, A1 may be "5" so I need a formula that adds all numbers between columns A2:E2 (5 columns) and
if A1 changes to "6", then I need it to add all numbers between A2:F2 (6 columns) and likewise
if A1 changes to "4", then I need it to add all numbers between A2:D2 (4 columns) and so on...
Can't find anything useful in Google so I though I ask the experts.
Bookmarks