This content has been marked as final. Show 7 replies
I am trying to solve a data problem. I need to create a formula that takes the sum (based on column A) of "to X" value minus the corresponding value in "balance" for X. The similar will apply for the "to Y". Another restriction is that variables in column "C" will differ, so there must be a restriction for this as well.
|A||B||C||Balance||To X||To Y||TO ALLOCATE X||TO ALLOCATE Y|
The two last columns "TO ALLOCATE X" and "TO ALLOCATE Y" shows the numbers that I would like to achieve.
Can anyone please help me with this issue?