$30,275 - 100 transactions @ $300 + 1 transaction @ $275
However, if they were laid out as two transactions:
100
1
Your formula would correctly calculate the first transactional value at £30,000, but then would put the second at $30,275, because it would add the value of the 1st 100 transactions to the 2nd single transaction.
And that's how I understand cumulative SUM...Originally Posted by Andrew-R
But also we have now Marcol solution that also have sence...
Now we only need to wait and see what user expect as result.
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks